- Create a query that contains the table whose records you want to append to another table.
How?
- In query Design view, click the arrow next to Query Type
on the toolbar, and then click Append. The Append dialog box appears.
- In the Table Name box, enter the name of the table you want to append records to.
- Click Current Database if the table is in the currently open database. Or click Another Database and type the name of the database where the table is stored. Type the path if necessary.
You can also enter a path to a Microsoft FoxPro, Paradox, or dBASE database, or a connection string to an SQL database.
- Click OK.
- Drag from the field list to the query design grid the fields you want to append and any fields you want to use for setting criteria. Also, you may or may not want to add the primary key field if it has an AutoNumber data type. For more information, click
.
If all the fields in both tables have the same names, you can just drag the asterisk (*) to the query design grid. However, if you're working in a database replica, you'll need to add all the fields instead.
- If the fields you've selected have the same name in both tables, Microsoft Access automatically fills the matching name in the Append To row. If the fields in the two tables don't have the same name, in the Append To row, enter the names of the fields in the table you're appending to.
- In the Criteria cell for the fields that you have dragged to the grid, type the criteria on which additions will be made.
For information on specifying criteria, click .
- To preview the records that the query will append, click View
on the toolbar. To return to query Design view, click View 
on the toolbar again. Make any changes you want in Design view.
- Click Run
on the toolbar to add the records.