To append data from one table to another, create an append query and then run the query:
- In the Database window, click Queries, and then click New.
- In the New Query dialog box, click Design View, and then click OK.
- In the Show Table dialog box, click the Tables tab, and then click the table that has the data that you want to append.
- Click Add, and then click Close.
- In the field list that appears, double-click each of the fields that you want to append to the second table.
- On the Query menu, click Append Query.
- In the Table Name box, select the table where you want to append the records.
- If the selected table is in the database that is currently open, click Current Database. Otherwise, click Another Database and then type the path and name of the database.
- Click OK.
- Examine the Append To area of the query grid and make sure that the query fields are mapped as they should be.
- On the Query menu, click Run.
- Click Yes to the message that says you are about to append # rows, where # is some number.
- Save and close the query, and then view the table where the information is appended.