Exporting to Excel

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

Guest

I am trying to export the results of a query in Access 97
to a table in Excel. When I try to run the export I get
the following error - "There are too many rows to output,
based on the limitation specified by the output format or
by microsoft access." I thought Excel's limitation was
around 65,000 records. Our output right now is a little
over 18,000 and the same exact process worked as little as
a week ago. Any idea what might've happened?
 
Excel 97's limitation is 65536 rows per spreadsheet.
Make sure you are selecting this version of Excel in the
Save As Type specification below the filename. There are
older versions listed before it.
 
Some of the ways of exporting to Excel use the old Excel 7.0/95 file
format, which has a limit of 16384 rows.

To get more, you need to use File|Export (without checking "Save
Formatted") or DoCmd.TransferSpreadsheet and specify Excel 97 or later
format.
 
Back
Top