Friday, May 01, 2015

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

No comments: