Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Friday, June 20, 2008 – Permalink –

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.

[Edited entry from 2/23/2005]

See all Topics


<Doug Klippert@ 6:45 AM

Comments: Post a Comment

Links to this post:

Create a Link