overflow on export to excel

[Kannan]

Hi,

When I export access report to excel, I'm getting overflow error at specific
page. I've checked for any errors like divide by zero and so on. But
everything is perfect. But Still I'm getting the overflow error. Can anybody
please help me on this?

Regards
Kannan

 

[George Nicholson]

Not sure if this will help, but Overflow errors also pop when variable size
is an issue. For example, trying to assign 32,800 to a variable declared as
Integer (Integer limit is 32,767). Changing variable declaration to Long
resolves error.

Not sure if this is applicable to your situation, but thought it worth
mentioning.

Good Luck,

 

[Kannan]

Hello George,

Thanks for your reply. I've tested all these integer limits as well. Still I
could not find out why this is happening. Now I'm removing each column and
run the report to find out in which column the overflow is occurring. So that
I can analyse the data being passed to that column.

The same report does not give any issues while exporting to RTF format. It
gives error only when exporting to excel.

Any other suggestions would be grateful.

Regards
Kannan

 

[Evi]

Here's a long shot. Do any of your Table's fields have the same name as a
function eg Page, Group, Date, Eval?
Evi

 

[Kannan]

Nope.

None of the field's having keywords as name.

Regards
Kannan

 

[Chuck]

Nope.

None of the field's having keywords as name.

Regards
Kannan

If you print the report, does it look like it would layout nice and neat on an
Excel grid?

Instead of exporting a reports data to Excel, how about, in Excel, importing
the data source for the report to a sheet in an Excel file?

Chuck