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
 

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

Combine Duplicates in Query 0
MS ACCESS INVENTORY CALCULATION 0
Multiple make table queries in one? 3
Make table query: [Enter 1] AS Test 1
Extract info from Multiple Tables & combine into 1 1
Error -1524 1
Make Table Query with path Parameter 1
Append Query, New Column help 1

Back
Top