Export Error Table created After Exportin A Table From Access ToExcel?

[Barbara Schneier]

I received a Database with a number of tables that each contain 24272
rows of data. When I export any of the tables to Excel a table is
created in Access with the name of the Exported file and the word Error
which contains 2 fields -- One field states: "Rows dropped due to
worksheet" and the other field states the number of rows dropped
"16384." Is there a limitation either in Access or Excel as to how many
rows can be exported to Excel or imported into Excel?

 

[Joe Fallon]

A lot depends on the versions involved and the way it is exported.

If you use code and DoCmd.TransferSpreadsheet then you can choose the
version of Excel.
I think Excel 97 and newer support about 32,000 rows instead of 16,000.

If you use Save As
Export...
then it may use Excel 5 by default and it may be limited to 16,000.