Hi,
I ussually run a report that can have up to 40000 records.
Sometimes I need to export it into Excel. When the report rows are over 33000 rows (more or less - I don't know the exact figure where it starts failing) I get the "Overflow" error and I can't export it. If the report is smaller than that, then I can do it.
It appears to me that it might have something to do with the Integer data type limit, which is, I think, 32767 but even having that into account I don't know how to fix it.
Is there something I can do about this?
Thanks!
OVERFLOW ERROR WHEN EXPORTING INTO EXCEL
-
- StarLounger
- Posts: 76
- Joined: 04 Jan 2013, 12:07
-
- Administrator
- Posts: 78464
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: OVERFLOW ERROR WHEN EXPORTING INTO EXCEL
Exporting a report to Excel has long been a weak feature of Access; it hasn't been kept up-to-date so it doesn't handle more than 32,767 records.
Try exporting to a .csv file. This can handle an almost unlimited number of records, and .csv files are opened in Excel by default.
Or export the table or query that acts as record source for the report. This has been updated, in Access 2007 and later you can export to a .xlsx workbook. This can handle more than a million records (up to 1,048,575 to be precise).
Try exporting to a .csv file. This can handle an almost unlimited number of records, and .csv files are opened in Excel by default.
Or export the table or query that acts as record source for the report. This has been updated, in Access 2007 and later you can export to a .xlsx workbook. This can handle more than a million records (up to 1,048,575 to be precise).
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 76
- Joined: 04 Jan 2013, 12:07
Re: OVERFLOW ERROR WHEN EXPORTING INTO EXCEL
Both alternatives sound quite reasonable.
Thanks a lot.
Thanks a lot.