Excel weekly reports in Access

[Yukipilas]

Hello Everybody,

I would like to ask a general question about capabilities of excel and Access.

For my job we receive weekly large amounts of data from our plant. We usually take the data from one week and do diagrams and analysis.

I am interested in integrating all the weekly data into one data base and enable the possibility of us to find specific information from one source.

For example i have the data for pressure and temperature of a vessel recorded each hour for 1 week. I would like to access my data bank and tell it to download the data from a certain week and make a graphic out of it.

How could i do this?, if understand right, I could load the excel tables in a access data base and process it to my convenience (graphs, diagrams etc..)

I appreciate general guidance just to push me in the right direction 

thank you all ,


Best regards,

Miguel

 

[alansidman]

crossposted: Excel weekly operative data in to Access

 

[Yukipilas]

Thank you for the notification i have modified the post,

regards,

Miguel