Export to Excel report with more than 17000 rows

  • Thread starter Thread starter Nikola Milic
  • Start date Start date
N

Nikola Milic

Hi,
I have simply report (made just for testing, no formatings, no headers, no
VB) which has 17000 rows with one integer column only. When I try to export
it to Excel (using Access's built in Export in File menu or Office Links
Publish with Excel) I'm getting error "There are too many rows to output,
based on the limitation specified by the output format.".

Why is this happen? Excel has limitation of 65356 rows, my report should fit
there.

I'm using Office 2000 on Win2000 SP4.

Thanks in advance
Nikola Milic
 
Hi again,
I've found this
http://support.microsoft.com/default.aspx?scid=kb;en-us;201589

RESOLUTION
To work around this behavior, use one of the following methods:
.. In Access, click Export on the File menu, and then export to Microsoft
Excel 97-2000 format. Make sure that the Save formatted check box in the
Export Table dialog box in Access is not selected. Then open the file in
Excel.

NEW PROBLEM
But Save formatted check box IS SELECTED AND DISABLED.

Is there work around for this work around?

Thanks in advance
Nikola Milic
 
Back
Top