How to Append Queries in Microsoft Access [Solved]

How to Append Queries in Microsoft Access

Access LogoAn Append Query is an action query (SQL statement) that adds records to a table. An Append query is often referred to as an Insert Query because the SQL syntax uses the INSERT INTO command.

Microsoft Access 2013 Append Query Ribbon to Insert Records into a Table
Append Query Option when Designing Queries in MS Access 2013

Microsoft Access Query Ribbon to Specify Append Query to Insert Records into a Table
Append Query Option when Designing Queries in MS Access 2007 and 2010

Append Queries are very powerful and lets you combine data from multiple tables and/or queries, specify criteria and put them into fields of an existing table. Think of it as a SELECT query where you can save the results in a table. The field names of the source and target tables do not need to match. In fact, you can create expressions to combine fields, use VBA functions, etc., to insert new values into the table.

Append Queries make it easy to save data at a point in time, use the data for temporary analysis, and display it in forms and reports. Of course, once in the new table, any edits in the new table do not impact the data in the original source. If that’s needed, stick to SELECT queries.

Designing an Append/Insert Query

From the Microsoft Access query designer, you can interactively create a query and specify its type. When you select Append, you are prompted to enter the name of the table that you want to insert records:

Microsoft Access Append Query Dialog for the Table Name to Insert Records

Specify the name of the table from the combo box. The table should already exist in your database.

The query designer is similar to how you’d create a SELECT query. You can specify criteria, create expressions, link between multiple tables and queries, etc. The difference is an “Append To” row that specifies which field in the target table each column is inserted into:

Microsoft Access Append Query Design Example

Notice in the example above that the Source field is called Memo that is being inserted into the Description field of the target table. Append Queries make it easy to put fields into different field names. It can also be an expression (formula) that’s inserted into a field.

Once the query is saved, you can run it to insert the records into your target table. If you want just this query’s results in that table, empty the table first before running the append query. You can create a Delete Query to empty all the records and run that first.


Leave a Reply

Your email address will not be published. Required fields are marked *