MS Access 2003: Integrate with Make-Take Query
This MSAccess tutorial explains how to integrate a pass-through query with a Make-Table query in Access 2003 (with screenshots and step-by-step instructions).
How to Integrate a Pass-through Query with a Make-Table Query
One of the limitations of using a pass-through query is that it can only access data from your external database. So if you need to move the data from the external database into your Access database, you can create a Make-Table 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 Make-Table Query.
When the Make Table window appears, enter the name of the table that you wish to create. Click on the OK button.
Now, when you run your Make-Table query, your new table will show in the Database window and it will be populated with data from your external database.
Advertisements