Merging tables

R

rokjock

I would like to combine two of my tables but cannot figure out how(they have
very similiar fields). Thanks in advance for any help!!
 
A

Allen Browne

Assuming you want the records from Table2 merged into Table1:

1. Create a query into Table2.

2. Change it to an Append query (Append on Query menu).
Access will ask which table to append to, and add a new row to the grid.

3. Use the Append To row to map the fields. (They will map automatically if
they have the same names).

4. Run the query.
 
Top