#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    7
    Rep Power
    0

    MYSQL ODBC & Microsft Query Problems


    I have a local instance of MYSQL with a table of data with approx. 1.2 million records. I have the mysql-connector-odbc-5.2.4-ansi-winx64 ODBC connector installed on Windows 7 x64.
    I can connect to the data table and load the data into excel only if I do not select any filtering in the MS Query wizard.

    If I try to apply any filtering, the MS Query tool stops working and faults.

    Any suggestions?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    7
    Rep Power
    0
    Does anyone out there have experience with similar problems of the MYSQL ODBC connector being used with the Microsoft Query Tool in Excel 2010?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    3
    Rep Power
    0
    give me your email address lets help each other out
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    7
    Rep Power
    0
    I would prefer to work through it here on the forums so anyone else can also benefit from solving the problem.

IMN logo majestic logo threadwatch logo seochat tools logo