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
 
Back
Top