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
 
Back
Top