Check name of driver in ADO string.
you can use "open file for" method with split() function.
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.
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.
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.