Results 1 to 8 of 8

Thread: Power query from ODBC error:" Arithmetic operation resulted in an overflow"

  1. #1

    Question Power query from ODBC error:" Arithmetic operation resulted in an overflow"



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good day. I am quite new to using power query and VBA. I am trying to pull a query from our ODBC connections. Some of our queries result in the error " Arithmetic operation resulted in an overflow" . Is there something wrong with my SQL statement or is the fault at my ODBC connection. Can someone please explain to me why this error occurs, and how to rectify this. Thank you in advance

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    Power Query and VBA? I wasn't aware that PQ was exposed to VBA.

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Power Query and VBA? I wasn't aware that PQ was exposed to VBA.
    Sorry Meant whatever language you need to use in the SQL statement. Everytime I want to pull data into a query from our servers it gives the error "DataSource.Error: Arithmetic operation resulted in an overflow". What is the reason for this error, and how do I get past this bump.
    Last edited by Arnoux; 2015-03-23 at 04:04 PM.

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    What are you connecting to in your data source?

  5. #5
    Im connecting to a MySQL database with an ODBC 3.51 connection.

  6. #6
    MySQL 5.1.11

  7. #7
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    I know nothing about MySQL I am afraid, but I know that Power Query has MySQL as an option in the database list, have you tried that rather than via the ODBC option (it might well be the same, but worth trying).

  8. #8
    Quote Originally Posted by Bob Phillips View Post
    I know nothing about MySQL I am afraid, but I know that Power Query has MySQL as an option in the database list, have you tried that rather than via the ODBC option (it might well be the same, but worth trying).
    Thanks Bob. I have tried that. Doesn't want to work with our server because it is ODBC.

Posting Permissions

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