Export/Output Data In Table To Excel Limitations

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

Guest

I've been trying export and output data in a tables that contains about an
average of 45,000 records which is below the 65,000 rows that Excel can store
in each worksheet. I keep getting an message when doing this export/output
"There are too many rows to output, based on the limitation specified by the
output format or by (my database name). I using Access 2000 and Excel 2000
with a XP platform. Any idea of what I can do to get this to work.
 
What method are you using to export? Are you using TransferSpreadsheet? If
so, did you specify the spreadsheet Type or did you use the default for
spreadsheet type? The default is Excel 3 (which if I recall correctly has a
limit of 16,000 rows).

If you didn't use transfer spreadsheet, what method are you using.
SendObject uses an older version of Excel also, so that could be the
problem.
 
Back
Top