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?
 
Back
Top