Better method for Exporting to Excel

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

I've been using the DoCmd.OutputTo command to simply create a spreadsheet
from a query but it appears to only save as Excel 5 format from Access XP
2002 and I think the only option is "acFormatXLS". Is there another method
to create a simple spreadsheet from a Query without opening the spreadsheet?
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Exporting to Excel, Set Sheetname 3
Exporting ACCESS Stored Procs into Excel 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
DoCmd.OutputTo acOutputQuery acFormatXLS to 97-2003 not 2005 2
Open an excel spreadsheet and run a macro from Access VB 2
Export to Excel 1
Export data from filtered subform to Excel ? 1
Exporting table to Excel - getting error - help please. 2

Back
Top