Friday, July 8, 2011

No ODBC Drivers available for Excel or Access etc in Windows 7 or Windows Vista

No ODBC Drivers available for Excel or Access etc in Windows 7 or Windows Vista


No ODBC Drivers available for Excel or Access in Windows 7 or windows Vista, Even after a complete new installation of Windows 7 and Office 2003 professional or Office 2007 professional on another computer.

When you try to add a driver in the ODBC Data Source Administrator, the response is: "To install new drivers use the driver's setup program!"

In the ODBC Data Source Administrators Windows only the SQL-Native Client and SQL-Server, from Microsoft shows to be installed.

The solution to the above problem is that instead of using Data Sources (ODBC) from Control Panel, just RUN the following file and you will get the ODBC Drivers installed there and start using them

RUN: c:\windows\SysWOW64\odbcsys32.exe or Matching .exe file in Windows Vista