Exporting to Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: djh (anonymous_at_discussions.microsoft.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 13:10:08 -0700

Excel 97's limitation is 65536 rows per spread***.
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
>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?
>.
>

Quantcast