overflow on export to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kannan - 11 Mar 2008 13:57 GMT

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

Reply to this Message

George Nicholson - 11 Mar 2008 16:53 GMT

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,

Signature

HTH,
George

> Hi,
>
[quoted text clipped - 7 lines]
> Regards
> Kannan

Reply to this Message

Kannan - 12 Mar 2008 08:56 GMT

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

> 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
[quoted text clipped - 17 lines]
> > Regards
> > Kannan

Reply to this Message

Evi - 12 Mar 2008 10:58 GMT

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

> Hello George,
>
[quoted text clipped - 36 lines]
> > > Regards
> > > Kannan

Reply to this Message

Kannan - 12 Mar 2008 13:40 GMT

Nope.

None of the field's having keywords as name.

Regards
Kannan

> Here's a long shot. Do any of your Table's fields have the same name as a
> function eg Page, Group, Date, Eval?
[quoted text clipped - 43 lines]
> > > > Regards
> > > > Kannan

Reply to this Message

Chuck - 13 Mar 2008 13:52 GMT

>Nope.
>
[quoted text clipped - 50 lines]
>> > > > 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

Reply to this Message