F Florin Feb 27, 2009 #1 I'm working in Access2003 and I want export query or raport in Excel. How can I do this, in VBA? Thanks
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 Feb 27, 2009 #2 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.
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.
