Run C:\Windows\System32\odbcad32.exe (This is the default shortcut in Administrative Tools).
"Microsoft Excel Driver" or "Driver do Microsoft Access (*.mdb, *.accdb)" are part of the (ACE) or the older Jet engine. Location: odbc driver location windows 7
If you install a driver (like MySQL ODBC) and it doesn't appear in your ODBC Administrator list, you likely installed the 32-bit driver but are looking at the 64-bit administrator (or vice versa). Run C:\Windows\System32\odbcad32
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC
A 32-bit process cannot load a 64-bit DLL. You must install the 32-bit version of the same driver. Many vendors provide both in one installer or separate downloads.
| Windows 7 OS Type | Folder Path | Bitness of drivers inside | |-------------------|-------------|---------------------------| | 64-bit | C:\Windows\System32 | drivers | | 64-bit | C:\Windows\SysWOW64 | 32-bit drivers | | 32-bit | C:\Windows\System32 | 32-bit drivers |
Locating ODBC drivers on Windows 7 is a matter of understanding the bitness duality, the physical folders System32 (64-bit drivers) and SysWOW64 (32-bit drivers) on 64-bit systems, and the registry under HKLM\SOFTWARE\ODBC\ODBCINST.INI and its WOW6432Node counterpart.
