Creating An Append Query

To create an Append Query do the following:

1. Select a new query.
2. Add the table you are pulling from.
3. By the default the query is a ‘Select’ type.
4. Select the table you are to append or insert into
5. Select the fields to be insert into the table.
6. Drag the select fields from the section of the dialog to the field section in the bottom of the dialog. If the field match up correctly, you are done.

Note that the SQL created looks as follows:

INSERT INTO TOwWildCardWKey
SELECT TOwWildcard.*
FROM TOwWildcard;

The word append is not used in SQL.

Double clicking on the field to be include to automatically include the field in the bottom half of the dialog called the query design grid.