Exporting to Excel

[Chris E.]

My Access 2002's export interface (ISAM) seems to be associated with earlier
versions of Excel and limits the numbers of rows that can be exported to
16,000. How do I fix it so that I can export more rows?

 

[Douglas J. Steele]

The TransferSpreadsheet lets you specify a spreadsheet type as the 2nd
argument. I don't have Access 2002 installed, but in Access 2003, the
choices are:

acSpreadsheetTypeExcel3
acSpreadsheetTypeExcel4
acSpreadsheetTypeExcel5
acSpreadsheetTypeExcel7
acSpreadsheetTypeExcel8 default
acSpreadsheetTypeExcel9 default
acSpreadsheetTypeLotusWJ2 - Japanese version only
acSpreadsheetTypeLotusWK1
acSpreadsheetTypeLotusWK3
acSpreadsheetTypeLotusWK4

 

[Larry Daugherty]

Can you export to >CSV format instead. There is no reason for that to be
limited and then you can import it to Excel.

HTH