Exporting to Excel

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

Guest

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?
 
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
 
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
 
You must log in or register to reply here.

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

2007 Data Export Limit 2
Rounding difference in Access 2003 text exports 2
Export Records Into Existing Excel File 1
Export large query from Access 3
Exporting to Excel from Access 3
Trouble exporting Report to Excel 1
Export query to Excel fails 6
Export to Excel + execute multiple query 1

Back
Top