maximum number of records in recording

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
 
J

John Nurick

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.
 
R

Ronald W. Roberts

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top