Exporting to Excel encounters row limitations

[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?

 

[PamS]

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.

 

[PamS]

Sorry MSKB is the knowledge base. Also my version is
Access 2002 (10.4302.4219) SP-2

 

[Joe Fallon]

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