Export Query to Excel

[Guest]

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

Thanks,

 

[George Nicholson]

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,

 

[Jeff Boyce]

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