Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    13

    Unanswered: Error Message "Overflow"

    I'm trying to export an Access report to MS Excel and I'm getting an "overflow" error. The report is only 24 pages, and should be about 700 lines (rows) of data. I know that Excel can handle it, but I'm stuck as to why the error message.

    Thoughts?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Don't have any experience exporting to Excel, but Error 6 Overflow usually means that you're trying that place a number into a field whose datatype is too small to hold it, i.e. trying to place 65000 into a field defined as Integer, whose limit is 32767.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Feb 2002
    Posts
    108
    I have gotten this error (just today) because I put "#" instead of "'" around a text object in the code of a report filter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •