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.
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
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.