Export to Excel 2000/2003 from Access 97

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
 
J

John Nurick

Use TransferSpreadsheet and specify
acSpreadsheetTypeExcel9
for the format argument.
 
Top