Unofficial Access Stuff

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

Host your Web site with PureHost!

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.

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

Access processes the queries and saves the results as a table with the same name as the original query.

See all Topics access
Labels: General, Queries, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:32 AM

Comments: Post a Comment