table to excel

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a table with 32,900 records in it. I tried
to "Analyze with Excel" but I run into an error message.
The message says, "There are too many rows to output,
based on the limitation specified by the output format or
by Microsoft Access." I made a copy of the db and had to
go to 10,000 records to make it over to Excel. Is there a
place I can go to and change the amt of output so more
records can be sent to Excel?
*** John
 
I think Analyze uses the old Excel 5.0 format and you can't change it and it
is limited to 16,000 rows or so.

Use TransferSpreadsheet and identify a newer version of Excel.
 
Not all Excel versions have the 65500+ rows

tray File>Export where you can choose the version of
excel you have
 
Back
Top