Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









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

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  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.



See all Topics

Labels: ,


<Doug Klippert@ 6:49 AM

Comments: Post a Comment