Query from an Excel spreadsheet

J

John Menken

I am using MS Access 2007 and I really like the idea of using it to
query an Excel spreadsheet. The problem that I'm having is that an
updated spreadsheet is posted once a week and its filename changes to
reflect the date of the posting. The one and only tab in the
spreadsheet also changes to reflect the current date. Is there a way
to program this "change in names" into Access so that the import and
queries that I set up will still work with the latest posted
spreadsheet?

Also, the data in the spreadsheet is identical from week to week. The
records may change but the column headings are always the same. Many
thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add additional information to excel form after original data entry 0
Integrating information from Word to Excel (not mail merge) 1
Need Help with Macro Security 1
Export BPMN Visio Chart to Excel 0
Dealing with a Pivot Table (when I don't want to) 0
Using Office Forms and dynamically updating the excel backend 0
Excel - Wich Function should I use? 1
Dumb question alert! What program to use? 0

Top