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.
 
G

Guest

If you use File>export you can choose XL97 format (which is the same as XL2003)

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting from Access 2003 & Access 2007 to Excel 1
Macro to export query to Excel 2
Output to Excel 2
Export as HTML 2003 2
Choosing Excel version 2
Export from Access 2007 Report to excel 3
Export to Excel 97-2003 not allowed 2
can't export from Access 97 to Excel 4

Top