Make Table Query

  • Thread starter Thread starter Clayton
  • Start date Start date
C

Clayton

I need to combine the data in several identical access
databases into one database location. (so data from each
identical table from each database would combine and be
stored in just one table, and this would be true for each
table.) So the plan would be to copy all of the tables,
and then create a "make table" query. Can anyone help me
with exactly how I would form this "make table" query?
Thank you in advance.
 
Hi Clayton,

The quickest way to APPEND data is to simple copy and paste from one table to another ('Select all' in one table and select the blank line at the bottom of the second table and paste). The tables MUST have the same structure - it will tell you if they don't.
Alternatively the APPEND query may be what you need. This should be straight forward.

regards
Laurie Eaton
 
Back
Top