Append One Existing Table to Another

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

How is this done? I have several tables that I imported
from other applications, and now have to join them all.
I am using Access 2003.
 
How is this done? I have several
tables that I imported from other
applications, and now have to join
them all. I am using Access 2003.
Click to expand...

If you truly mean tables with the same data structure, and you really want
them put together into one table, then you can use an Append Query. If same
data structure, and you just want them appened one behind the other to use,
but not to store, check help for the UNION and UNION ALL in SQL statements
(you have to use these in the SQL view; there is not a graphic
representation in the Query Builder grid).

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

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

Appending records 1
Tables: Appending Data, Link or Not to Link, That's My Question... 6
Can't create append query 2
Importing into existing table 5
Append two tables 3
Append Access Data to SQL Server Table 12
Replacing a Table with a Table from another database - reference issues 1
Access Access 2010 import/append data into table w/o overwriting existing records 0

Back
Top