Import Queries

As Tables

If you want to use the results of a query, and you don't need to update the underlying tables, you don't have to import unnecessary data.

You can import the query as a new table.

1. Select File>Get External Data Import from the menu bar.
   (External Data tab, Import in 2007+)
   
2. Select the appropriate database and click Import.
   
3. Select the queries you want to import on the Import Objects dialog box's Queries sheet.
   
4. Next, click the Options >> button and select the As Tables option button on the Import Queries panel.
   
5. Finally, click OK

Access processes the queries and saves the results as a table with the same name as the original query.



See all Topics