MS Access 2003: Integrate with Append Query
This MSAccess tutorial explains how to integrate a pass-through query with an Append query in Access 2003 (with screenshots and step-by-step instructions).
How to Integrate a Pass-through Query with an Append Query
If your table already exists in Access, but you need to move the data from the external database into this table, you can create an Append query that uses the pass-through query as input.
Let's look at an example.
First, create a new Query. When the Show Table window appears, click on the Queries tab. Then select the pass-through query that you just created. In this example, our pass-through query is called Query1. Then click on the Add button.
Next, select the fields from Query1.
Under the Query menu, select Append Query.
When the Append window appears, enter the name of the table that you wish to append records to. Click on the OK button.
Your Append query should now look like this.
Now, when you run your Append query, your table will be populated with data from your external database.
Advertisements