You can export a table or a query to a blank spreadsheet using the following VBA.
DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9, "Query1", "
FullPathAndFileName", True
THis example uses Excel 2000 format. You can change the argument to match your needs. Be sure to include the correct file extension type in the Full Path and Name of your Excel file that you are exporting data to.
Here is a list of some constants that you can use
http://msdn.microsoft.com/en-us/libr...ffice.14).aspx
acSpreadsheetTypeExcel7 or simply the number 5 would tell Access to save the file as 95 format.