maximum number of records in recording

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

I need to export some tables to excel. Sometimes it pops
up with message like too many records to be exported.

What is the maximum number of records can I export to an
excel format?

Thanks,

Shirley
 
Hi Shirley,

As far as I can make out:

If you're exporting to one of the older Excel formats, or using "Analyze
with Excel", the Save Formatted option in File|Export, DoCmd.OutputTo or
the Output To macro, the limit is 16384 rows.

Using File|Export without Save Formatted (or DoCmd.TransferSpreadsheet
or the equivalent macro), to Access 97 or later format, the limit is
65536 rows.
 
Shirley said:
I need to export some tables to excel. Sometimes it pops
up with message like too many records to be exported.

What is the maximum number of records can I export to an
excel format?

Thanks,

Shirley
Click to expand...
Excel 97 and later versions is 65,536 rows.
Older version of Excel is 16,000 plus rows.
In your export select Excel 97, not Excel 3, 4, 5-7.

Ron
 
Back
Top