Sound like you want an append query that takes all of the records from one
table and appends them to the other.

You can easily do this in the query design view.  Create a query that
selects all the fields from one of the tables.  On the "Query" menu, choose
"Append Query", and specify that you want to append the data to the other
table.  Run the query.

This will NOT work if there are duplicate primary keys across the two
tables.  If that is the case, what you need to do will depend on how,
logically, you want to resolve the duplicates.

Use an append query and append table2 into table1.

--
                                       PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                             resource@pcdatasheet.com
                                www.pcdatasheet.com