By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Overflow Error while Exporting access reports to excel file

P: 4
Hi All,
I have got stucked up in one problem from many days.
I have one report in Access 97. When I do right click on it and select option "Save As./Export". It gives me Error as "Overflow".. Actually I am very new to Access. So please help me.
Sep 12 '07 #1
Share this Question
Share on Google+
6 Replies


Denburt
Expert 100+
P: 1,356
I'm not sure this will help but It sounds like you are trying to export the report while it is closed, try opening the report then export it. Let me know if this helps.
Sep 12 '07 #2

P: 4
I'm not sure this will help but It sounds like you are trying to export the report while it is closed, try opening the report then export it. Let me know if this helps.
Thanks a lot for your quick response.
Actually I opened it and then tried to export it..It gives the same error.
Can you advice?
Sep 12 '07 #3

JKing
Expert 100+
P: 1,206
If you're using calculated fields on your report ensure that no nulls are being passed through that would disrupt those calculations.
Sep 12 '07 #4

Denburt
Expert 100+
P: 1,356
JK is right for the null values as well as any fields that may contain errors, remember that there can be hidden fields only viewable in in design view etc. Is this a report that you designed or have you taken it over from some other designer? I was also wondering what you might be trying to export it to? I have witnessed many issues in exporting due to the fact that a field may contain numbers and text. The field may be a text field but when MS Access sees the numbers it doesn't matter numbers it is so it will error out and not export.
Sep 12 '07 #5

P: 1
I have a similar issue, however, 2 users are getting the overflow error on a particular report, yet when I export the report I don't get the overflow error.

Any ideas?
Feb 6 '08 #6

Denburt
Expert 100+
P: 1,356
I have a similar issue, however, 2 users are getting the overflow error on a particular report, yet when I export the report I don't get the overflow error.

Any ideas?
It can be hard to say without more info, there can always be so many variables in these situations. I have witnessed incidents where a particular P.C. may not have enough resources. I closed a few apps and sometimes that helps. Sometimes the P.C. with problems just doesn't have what it takes either.
Feb 7 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.