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.
Get this error when using excel .csv files for imports to SAGE MAS90.
July 25th, 2012 5:37pm

Check name of driver in ADO string.

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

Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 7:49pm

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.

July 26th, 2012 10:25am

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.


Free Windows Admin Tool Kit Click here and download it now
April 15th, 2013 4:11pm

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.

July 3rd, 2013 3:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics