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.
- Select File>Get External Data Import from the menu bar.
(External Data tab, Import in 2007+)
- Select the appropriate database and click Import.
- Select the queries you want to import on the Import Objects dialog box's Queries sheet.
- Next, click the Options >> button and select the As Tables option button on the Import Queries panel.
- Finally, click OK
See all Topics