Here is a table that shows which ODBC Administrator Tool to use: Windows OSĦ4-bit ODBC Administrator tool %systemdrive%\Windows\System32\odbcad32.exe, or Control Panel\System and Security\Administrative Tools\Data Sources (ODBC)ģ2-bit ODBC Administrator tool %windir%\SysWOW64\odbcad32.exeģ2-bit ODBC Administrator tool %systemdrive%\Windows\System32\odbcad32. Note: All Office versions prior to Office 2010 can only be installed as 32-bit applications. Underneath "About Microsoft Excel", you will see a version number and in parentheses 32-bit or 64-bit will be listed.Click on the File tab in the upper left corner.To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe.
#Odbc driver for excel 2010 64 bit driver#
To determine whether Office 2010 64-bit or 32-bit is installed, take the following steps: To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe.
#Odbc driver for excel 2010 64 bit drivers#
The second ODBC Administrator tool to manage the 32-bit drivers and DSNs on the machine can be launched from the SysWow64 folder. The 64-bit ODBC Administrator tool is the default dialog that is launched from the control panel and is used to manage the 64-bit drivers and DSNs on the machine. On a 64-Bit Windows operating system, there are two versions of the ODBC Administrator tool. For example, the default location on a Windows 7 64-bit machine is "C:\Windows\SysWOW64\odbcad32.exe". If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. To locate the 32-bit Office System drivers, use the appropriate version of the ODBC Administrator tool. I have Windows 7(64 bit) and Office 2010(64 bit).I need to use a Driver called Microsoft Access Driver(.mdb.accdb) (MS Access) ODBC driver which i could not use in my computer now.I have installed the 'AccessDatabaseEngine 2010圆4.exe' but still cant fix the problem. In 64-bit versions of Windows, there is a separate ODBC Administrator used to manage 32-bit drivers and DSNs.
This occurs when the 32-bit version of Office or the 32-bit Office System Drivers is installed on a 64-bit version of Windows. They are not visible in the standard ODBC Administrator dialog that is launched from the Administrative Tools dialog in the Control Panel. When attempting to create ODBC connections that utilize the Microsoft Office System Driver, such as connections to Access or Excel, on a 64-bit Operating system like Windows 7, the drivers are not visible. One reference said win7-64 no longer supplies ODBC drivers except for SQL. But, at this point Im no where close to understanding how/where to get 64bit Excel OCBC driver. Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows After reading your post I googled a bit and it sure sounds like you are right.
0 kommentar(er)
