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
 
Back
Top