Export Query to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First- I am not an advanced Access user. That said, can someone please
explain how I can export a query into Excel.

Thanks,
 
Quickest & easiest way I've found is to open the query in PrintPreview mode
and use the "Office Link>Analyze in Excel" button on the PrintPreview
toolbar. Creates a workbook in your default directory (probably MyDocuments)
with the same name as the query.

HTH,
 
Open Access in the database window.

Click on the Queries tab.

Highlight the query you wish to export.

Click on File | Export, and specific the form you wish the export to take
(e.g., Excel).

Try clicking on Access HELP and typing in "Export" for additional
assistance.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
Need help exporting an Office 365 mailbox to PST 1
Export to excel has character limit 3
Problem with Cross qry 1
Default Font 2
Query Key 3
Multivalue field and exporting to Excel 1
Query Export Issue 5

Back
Top