Error Message

[Matt]

I am attempting to export a Report to Excel and am running
into this error:

"There are too many rows to output, based on the
limitation specified by the output format or by Microsoft
Access."

I have about 33,000 records that need to be exported. I am
using the report so that I can establish the grouping.

Any ideas that could solve this problem?

Thanks for your help...Matt

 

[Dirk Goldgar]

I am attempting to export a Report to Excel and am running
into this error:

"There are too many rows to output, based on the
limitation specified by the output format or by Microsoft
Access."

I have about 33,000 records that need to be exported. I am
using the report so that I can establish the grouping.

Any ideas that could solve this problem?

Thanks for your help...Matt

How are you trying to export it? I searched the Microsoft KnowledgeBase
( http://support.microsoft.com/search/?adv=1 ) for the exact text of the
message you quoted, and found this article, which may be relevant:

http://support.microsoft.com/default.aspx?scid=kb;en-us;291951
You receive a "Too Many Rows" error message when you use "Analyze It
with MS Excel" in Access 2002