Discussion Locked

Overflow error in MS Access 2000

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I try to export a report from MS Access 2000 into MS Excel 2000 I am getting a box come up saying overflow. This is as far as it goes and it fails to do the export into MS Excel.

3 replies

by roc180

Couple of things come to mind.
1. When exporting to Excel, there is a limit to the amount of rows you can export. Its right around 32,000 rows.
2. Can any of your data be interpreted as a formula in Excel. The usual culprits are +,-,=, or *. Its very easy to have a text field in Access contain these characters, and Excel tries to evaluate the field as an expression.

Good Luck

Neal Martinelli

by tim schraider

Great! Thanks for that was getting a #num! in one of the columns of the report which was preventing it from exporting.

This discussion is closed to new replies.