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.
Wednesday, July 25, 2012 2:37 PMGet this error when using excel .csv files for imports to SAGE MAS90.
Wednesday, July 25, 2012 4:49 PM
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
Thursday, July 26, 2012 7:25 AMModerator
Monday, April 15, 2013 1:11 PM
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.