Trouble exporting Report to Excel

[ddean]

How do you increase rows to output size? When exporting a 2000+ page report
to Excel (97-2002 *xls), stops on page 412 with message stating: “There are
too many rows to output, based on limitation specified by the output format
or by Microsoft Accessâ€. Using Access 2000 with Windows 2000 OS

 

[Douglas J. Steele]

Excel has a hard-and-fast limit of 65536. When you export to Excel from a
report, you usually get extraneous blank lines, so it's conceivable that
you're hitting that limit.

There's no way around it, other than to simply export the data (assuming
less than 65536 rows) rather than the report.