Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-24-2007, 08:00 PM   #1
SAB
Registered User
 
Join Date: Apr 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
SAB is on a distinguished road
Question Overflow error while exporting to excel

Hi all,

I have a report that is generated properly no matter how big is the data (biggest one that I've tried is 375 pages).

After a report is generated, exporting to .rtf file (word) has no problem at all.

However, when I export to excel sometimes the Overflow error occurs.
It doesn't depend on the data size. Sometimes the error occurs on a report with small data size(about 60 pages).
However, the report with different data (about 100 pages) has no problem.

I've tried to find the cause of this for many days but still no clue at all for me.
and this problem is really urgent for me.

Do anyone has experience with this?

Thank you very much.

SAB is offline   Reply With Quote
Old 04-24-2007, 08:04 PM   #2
SAB
Registered User
 
Join Date: Apr 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
SAB is on a distinguished road
Here is the error screenshot
Attached Images
File Type: jpg overflow.JPG (6.9 KB, 565 views)
SAB is offline   Reply With Quote
Old 04-24-2007, 08:34 PM   #3
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
I know an Excel spreadsheet can only contain approximently 65,000 rows. How many rows are your trying to export. From the error is sounds like you are trying to export to many rows to the spreadsheet and causing an error.

__________________
If my post has helped you solve your problems please add to my reputation. Click the scale in the top right side of this post.
KeithG is offline   Reply With Quote
Old 04-26-2007, 03:23 AM   #4
SAB
Registered User
 
Join Date: Apr 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
SAB is on a distinguished road
Thank you KeithG.
However I'm sure that it doesn't exceed 65,000.
My data size is very less than that for sure.

I really have no idea how this occured.

Do anyone has other suggestions ?
SAB is offline   Reply With Quote
Old 04-26-2007, 08:36 AM   #5
shudini
Newly Registered User
 
Join Date: Mar 2007
Posts: 114
Thanks: 0
Thanked 0 Times in 0 Posts
shudini is on a distinguished road
When a report is exported to excel, i'm pretty sure all access is doing is exporting the query/queries bound to the report/subreport to an excel spreadsheet. Just for the heck of it, try to export the query instead of the report and see if you get the same error. If you do, most likely there's a data overflow in one of your fields. If so, can you please go into a little more detail on the fields and data types contained in the query?

__________________
Shuie
shudini is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting & Exporting Access 97 query result to Excel 2000 hadwin Modules & VBA 7 09-28-2005 12:50 AM
Exporting to Excel UDP Queries 1 08-04-2005 07:37 AM
Exporting to excel lipin General 1 03-12-2003 06:43 AM
Running excel macro after exporting data into Excel dwhite Modules & VBA 2 12-23-2002 07:11 AM
[SOLVED] Problem exporting DATE fields from Access to Excel SMG Queries 2 05-09-2002 10:35 AM




All times are GMT -8. The time now is 01:06 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World