Problem exporting Access Report to Excel

[Guest]

I get a message saying that the row output is too large. I have tried
exporting the report as a text file, the setup isn't right. I tried to
export it to Microsoft Word, it did do that, but I am having problems
converting it to a table. I really need for the report to be in Excel. Is
there any way to take the limit off of how many records can be exported?

 

[Guest]

Hi,

looks like that you exceed the maximum number of rows Excel can handle :
65535.
The only thing what comes into my mind is to split your report into several
others by filtering on some values and save them as separate reports.

Bernd