Compiling data questions

[tcambridge]

Hi,

I have multiple Excel files with data of locations and sale volumes for each month from 2008. I want to combine all data into one large database file where I can draw charts to show the sale volume from each locations over selected time (months, years). What will be the best and most effective method to do this? I was thinking to convert data to MS Access and go from there. Please help! :help

[ranman256]

Definitely Access is the way to query records over time and criteria. (but its a different animal that you would need some training on)

[snb]

The best method to get a fine answer is posting a sample data file and a sample of the database you want to create.

[tcambridge]

Please find attached sample data.