ACC2000: How to Append Data from One Table to Another

Article translations Article translations
Article ID: 306093 - View products that this article applies to.
This article was previously published under Q306093
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

Expand all | Collapse all


This article describes how to append data from one table to another table in Access.


To append data from one table to another, create an append query and then run the query:
  1. In the Database window, click Queries, and then click New.
  2. In the New Query dialog box, click Design View, and then click OK.
  3. In the Show Table dialog box, click the Tables tab, and then click the table that has the data that you want to append.
  4. Click Add, and then click Close.
  5. In the field list that appears, double-click each of the fields that you want to append to the second table.
  6. On the Query menu, click Append Query.
  7. In the Table Name box, select the table where you want to append the records.
  8. 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.
  9. Click OK.
  10. Examine the Append To area of the query grid and make sure that the query fields are mapped as they should be.
  11. On the Query menu, click Run.
  12. Click Yes to the message that says you are about to append # rows, where # is some number.
  13. Save and close the query, and then view the table where the information is appended.


For more information about about append queries, click Microsoft Access Help on the Help menu, type append queries in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.


Article ID: 306093 - Last Review: June 29, 2004 - Revision: 2.0
  • Microsoft Access 2000 Standard Edition
kbhowto KB306093

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from