How to Use Access to Append Data

Append data in Access by using the Append action query.

Access uses action queries to perform actions on the data in the database. Action queries can update, append, delete or make new tables in your database. The append query will add additional data based on query criteria. This query can quickly append new data your database tables. Once the append query is executed, you will be prompted to confirm the append action and confirm the number of records being added to the database.

Instructions

1. Open Access 2007 and select a database. Review the right task pane and select one of the databases in the "Recent Open Database" list. The database opens.

2. Click the "Create" tab and select the "Query Design" icon. Select a table from the Show Table dialog box by clicking the table name and selecting "Add." Close the Show Table dialog box by clicking the "Close" button.

3. Add fields to your query by double-clicking on the field names. The field names will populate the query window. Add a criteria to the "Criteria" field.

4. Turn the query into an append query by clicking the "Append" button on the ribbon. The Append dialog box appears. Select the table to append the data to. Select either "Current Database" or "Another Database." If you select another database, you will browse to locate the database to append the data to. Click "OK."

5. Run the query to perform the append by clicking the "Run" button. You will get a prompt informing you about the number of records that will be appended to your table. Confirm the prompt by clicking "Yes."

References

• Microsoft: Add Records to a Table by Using an Append Query