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

    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.


  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    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 that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Feb 2002
    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