Exporting to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 30 Jun 2004 19:35 GMT

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?

Reply to this Message

djh - 30 Jun 2004 21:10 GMT

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.

>-----Original Message-----
>I am trying to export the results of a query in Access 97
[quoted text clipped - 6 lines]
>a week ago. Any idea what might've happened?
>.

Reply to this Message

John Nurick - 30 Jun 2004 22:02 GMT

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.

On Wed, 30 Jun 2004 11:35:27 -0700,

>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
[quoted text clipped - 4 lines]
>over 18,000 and the same exact process worked as little as
>a week ago. Any idea what might've happened?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message