Originally Posted by
fashoda
Every month I create an Excel report, then import it as a table into Access. I created queries to pull certain data from that table. Queries work fine until I import the next months report. Every months table has the same column headings but different values. When I put the new table in the query and change the table to the new one and run it the numbers are all wrong. If I delete the old table everything disappears from the query grid. Basically what I want to do is run the same query every month on a different table. Please help