export query in Excel

F

Florin

I'm working in Access2003 and I want export query or raport in Excel.
How can I do this, in VBA?

Thanks
 
A

Allen Browne

Use TransferSpreadsheet to export a query to an Excel spreadsheet.

To export a report, use OutputTo.

In general, exporting the query is the better solution.
 
Top