Better method for Exporting to Excel

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