Exporting query results using VBA

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

When you export a table or query in VBA, you use syntax
like this:

DoCmd.OutputTo acOutputQuery, "nameofquery",
acFormatXLS, "nameofdestinationfile"

The problem I have is that acFormatXLS is not specific
enough. acFormatXLS saves my documents as a Microsoft
5.0/95 Workbook. I need the XLS file to be saved as a
Microsoft Excel Workbook, or as a Microsoft Excel 97-2000
Workbook.
 
Hi Brad,

Use DoCmd.TransferSpreadsheet instead.

When you export a table or query in VBA, you use syntax
like this:

DoCmd.OutputTo acOutputQuery, "nameofquery",
acFormatXLS, "nameofdestinationfile"

The problem I have is that acFormatXLS is not specific
enough. acFormatXLS saves my documents as a Microsoft
5.0/95 Workbook. I need the XLS file to be saved as a
Microsoft Excel Workbook, or as a Microsoft Excel 97-2000
Workbook.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top