Export to Excel 2000/2003 from Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Looking for a way to export tables from Access 97 directly
to Excel 2000/2003 format, instead of the default Excel 95
format. Anyone know of a way to do this please post!

Thanks
gm
 
Use TransferSpreadsheet and specify
acSpreadsheetTypeExcel9
for the format argument.
 
Back
Top