SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Jul 2002
    Location
    Columbia, MO, USA
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Numeric Field Overflow

    When reading in data from an excel spreadsheet I am receiving the error:
    Numeric Field Overflow. I've checked the fields for any numbers that might be too long and there aren't any. Has anyone ever received this message before? Any help would be appreciated. Thx!
    Jill Vannausdle

  2. #2
    Senior Member
    Join Date
    Jul 2000
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Numeric Field Overflow

    If you search the forum for this topic, you'll see endless discussions of the problem.

    The "easy" way out is to simply format every cell in your worksheet as TEXT. That is, select the entire worksheet, then do the format. You can do this on a cell-by-cell basis, but why bother? This is one of those times where brute force wins.

    ------------------

  3. #3
    Member
    Join Date
    Dec 2000
    Location
    India
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Numeric Field Overflow

    I agree with Brent Rolland. But I would also suggest you to download an odbc test tool. With the tool you can run your queries and find out if there are any errors. This you can do with out running the automated scripts. Saves a lot of your time and sometimes will help in debugging.

    I had faced a similar problem and used the ODBCtest tool know what was the data returned by the query. one of the fields was returning NULL (though the data was present!). I deleted the data in Excel sheet and and re-entered the data. It worked!

    Hope that helps.

    btvenkatesh@yahoo.com

    ------------------

 

 

Posting Permissions

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

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 05:33 PM.

Copyright BetaSoft Inc.