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








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, May 01, 2015 – 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@ 3:32 AM

Comments: Post a Comment