Combining Tables

[Matt]

Each week I have a new data table with the same columns as
the previous week. I know that I can copy/paste/Append to
Existing Table to combine all the data into one database
to work with. However, I am looking for an easier way to
access all my tables when doing queries. As an example, I
was to extract all my Tuesday values from each table.

 

[John Vinson]

Each week I have a new data table with the same columns as
the previous week. I know that I can copy/paste/Append to
Existing Table to combine all the data into one database
to work with. However, I am looking for an easier way to
access all my tables when doing queries. As an example, I
was to extract all my Tuesday values from each table.

I'd suggest linking to the new data table every week and running an
Append query (not copy&paste, that's for spreadsheets) to a master
table. You can use a UNION query to search all your tables together,
but with a table every week this query will become enormous,
inefficient, and very hard to maintain. The Append query can be run
from a macro or from code and should require very little user effort.

 

[Guest]

Where is your new data table coming from? Could you use a
macro to handle the appending of the rows each week so
it's not so much manual effort? That way all your
information is in one table and much easier to query
against.