Microsoft ODBC Administrator: The setup routines for the Microsoft Excel Driver (*.xls, *.xlsx,*.xlsm,*.xlsb) ODBC driver could not be found. Please reinstall the driver.


All replies

  • Check name of driver in ADO string.

    you can use "open file for" method with split() function. 

    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Wednesday, July 25, 2012 4:49 PM
  • Hi,

    Based on my research, I want to confirm that whether you have a 64 bit OS so trying to use a 64 bit ODBC Data Source Admin with a 32 bit application.

    If it is, then the resolutionis that use a 32bit ODBC Data Source Admin.

    Jaynet Zhang

    TechNet Community Support

    Thursday, July 26, 2012 7:25 AM
  • Hi,

    it took me a while to understand the issue - but here is the solution:

    32-Bit Excel needs 32-Bit ODBC-Adminstrator odbcad32.exe which lives in C:\Windows\SysWOW64

    64-Bit Excel needs 64-Bit ODBC-Adminstrator odbcad32.exe which lives in C:\Windows\System32

    We should not discuss neither the identical names of different files nor the misleading naming of a directory named something32 but contains 64-Bit-software.

    • Proposed as answer by Jetboy2k Wednesday, July 03, 2013 7:55 PM
    Monday, April 15, 2013 1:11 PM
  • John, thanks very much. I went to a number of different pages (most of them official MS sites) that had the "answer," none of which worked. This resolved my issue in 30 seconds.

    Thanks again, someone should DEFINITELY mark this as answered.

    Wednesday, July 03, 2013 7:56 PM