Discussion Locked
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
Great! Thanks for that was getting a #num! in one of the columns of the report which was preventing it from exporting.
This question was closed by the author
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending
0 helpful
1 reply
Question
Floppy drive wont work on my 486
0 helpful
1 reply
Discussion
How to make light speed agent go away
0 helpful
4 replies
Discussion Locked
Ryzen 7 7700
0 helpful
2 replies
Question Locked
Issue fully resetting my PC
0 helpful
4 replies