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.
All Replies
-
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- Proposed As Answer by VBAToolsMVP Wednesday, July 25, 2012 4:49 PM
- Unproposed As Answer by VBAToolsMVP Wednesday, July 25, 2012 4:49 PM
- Edited by VBAToolsMVP Wednesday, July 25, 2012 4:50 PM
- Marked As Answer by Jaynet ZhangMicrosoft Contingent Staff, Moderator Monday, July 30, 2012 1:09 AM
-
Thursday, July 26, 2012 7:25 AMModerator
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
-
Monday, April 15, 2013 1:11 PM
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.
.png)
