Import from Excel to Access

[darude]

Hi All,
I am looking for some advice. I am building an Access d/b for a client. They receive quarterly reports via email in an Excel template. I need to import those templates into Access to run various reports and want to automate the process. They already save the templates to one workbook (separate sheets). I thought I would reference all sheets to one sheet that ultimately looks like a table. Then create an automatic import to Access. Does anyone have any other ideas or does it sound like I'm on track. Any advice would be greatly appreciated. Thank you very mucho!!!

 

[rdeleon]

It sounds like your on the right track, but without knowing all the details regarding your data and requirements it is impossible to say for sure.

Based on the assumption that all the data you need is in the emailed spreadsheets. I would create an import function that would allow me to select the emailed spreadsheet, capture the quarter (200403, 200406, etc), and save in a database table. As the quarterly information is collected, you append the new information to the table. This would save all your information in one table and would allow you to perform trend analysis, aging, etc.

Just my 2 cents.

Rene'

 

[darude]

Thank you so much Rene. All the data I need is contained in the spreadsheets. I just want to automate it as much as possible. Thank you again.