Combining two tables to a third new one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take the contents of two tables and put them into a third new one.
How do I do that? Thanks in advance.
 
You would normally use an append query. Your specific sql syntax would
depend on if the table structures are the same or if the two tables are
related.
 
So create a new table then append it with both tables? These two tables are
identical in structure.
 
If you don't already have a third table and you are only doing this once, my
suggestion would be to create a make table query from your first table. This
will create the third table and append the records from the first table.
Switch the query to an append query. Remove the first table from the query
and then add the second table to the query. Add the fields from the second
table to the blank query grid. If the field names are the same, you should
automatically see the "Append To" fields in the grid. Then run the append
query.
 
Back
Top