Exporting to Excel encounters row limitations

  • Thread starter Thread starter PamS
  • Start date Start date
P

PamS

I am exporting more than 16,000 rows to an Excel 2002
spreadsheet, but if I use a macro or use Office Links-
Analyze with Excel, I encounter the old Excel row
limitations. I have to use the Export option and this
does not save the formatting. When will ACCESS recognize
the expanded row limitations in Excel 2002?
 
I'm not sure what "MSKB" is?

When I use TransferSpreadsheet I have the following
options,
Excel 3
Excel 4
Excel 5-7
Excel 8-10

I used Excel 8-10 and still same problem. If I use
OutputTo, it gives me a Excel 97-2002 option, but still
defaults back to plain .xls and still won't work.
 
I use Access 2002 to export records to Excel.
I just tested an export of 17,146 records and it worked fine.
(Excel 2002)

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "ExportData",
mFileName
 

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

Rows dropped due to worksheet row limit 1
export from access to excel 2
Export Access table to Excel that has more than 65000 records 5
Exporting limitations in Access 1
Export Record Limitations 1
Exporting to Excel 2007 1
Exporting from Access to Excel 5
Access-->XML-->Excel: Size Limitations? 0

Back
Top