none
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.

Réponses

Toutes les réponses

  • 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


    mercredi 25 juillet 2012 16:49
  • 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

    jeudi 26 juillet 2012 07:25
    Modérateur
  • 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.


    • Proposé comme réponse Jetboy2k mercredi 3 juillet 2013 19:55
    lundi 15 avril 2013 13:11
  • 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.

    mercredi 3 juillet 2013 19:56