Problems with exporting report to Excel

[hiwelcome]

Hello,

I'm having a couple of problems with this procedure. First, I am using the 2010 version of Office, if it matters.

The first problem is that when I try to export a report of any size to Excel, I get an overflow error. I haven't done extensive testing to see where the "problem number" is, but a report that pulls 7 records exports fine, but one that pulls 71 records gives the error. In case it is valuable info, I have tried to export the underlying query (as per the suggestion here: http://www.access-programmers.co.uk/forums/showthread.php?t=127360&highlight=export+overflow) and the query exports the 71 records fine. I can also export to .pdf with no problems. Any ideas?

The second problem is I have a Comments field (memo), and this also exports fine while exporting from the query. However, when exporting from the report, it only appears to take the first 255 characters to the corresponding field in Excel. Is there a fix/workaround for this?

 

[sneuberg]

Hello,

I'm having a couple of problems with this procedure. First, I am using the 2010 version of Office, if it matters.

The first problem is that when I try to export a report of any size to Excel, I get an overflow error. I haven't done extensive testing to see where the "problem number" is, but a report that pulls 7 records exports fine, but one that pulls 71 records gives the error. In case it is valuable info, I have tried to export the underlying query (as per the suggestion here: http://www.access-programmers.co.uk/forums/showthread.php?t=127360&highlight=export+overflow) and the query exports the 71 records fine. I can also export to .pdf with no problems. Any ideas?

I suspect their is something in the data that's causing the overflow; probably a number that's too big or something that's being interpreted as a computation whose result exceeds the maximums. If you can post or upload the data I would see if I can find the problem. If you can't do that I suggest testing this through divide and conquer, i.e., skip splitting the data in half and testing until you get to a single data record that causes the problem.

The second problem is I have a Comments field (memo), and this also exports fine while exporting from the query. However, when exporting from the report, it only appears to take the first 255 characters to the corresponding field in Excel. Is there a fix/workaround for this?

Apparently Memo Field Truncated When Report Is Output to Excel is a known problem. The link has work arounds.