Append Query

It create a query that contains the table whose records you want to append to another table.

1. You can append to only one or more fields, or all the fields to another table. What you must make sure is that the field names in the two tables must be the same. Otherwise it will show you an error message with an unknown field name.
2. Using my sample example, on the main menu, click Query->New and double-click Design View in the New Query dialog box.
3. In the Show Table dialog box, select the table "MalaysiaPlants", click Add, then close the dialog box.
4. Right-click the title bar of the Query1 window. Position the mouse on "Query Type" and click Append Query…
5. In the "MalaysiaPlants" list, double-click on "Material" field if you want to append only this field. Double-click the asterisk field if you want to append to all fields.
6. Save the query with any name.
7. To see the SQL statement, right-click the title bar of the Query1 window and click SQL View.
8. To execute the query, on the main menu, click Query->Run. You will receive a message box. Click Yes.
9. Open the "SingaporePlants" table, you will see that two rows from "MalaysiaPlants" table had been added to.