SQL - AccessDatabaseEngine

I am trying to create a Link Server with Excel. I am using SQL Server 2008 R2
(SSMS V 10.50.1600.1)  and I am using Office 2010 plus 32 bits.  I installed successfully AccessDataEngine.exe for ODBC Driver for Excel.  But when I use ODBCAD32.exe, I do not see the Excel driver being installed. Any idea?  See the attached file.

How do I install so I should get the Excel ODBC Driver?
Capture2.JPG
tommym121Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<But when I use ODBCAD32.exe,>>

  Make sure your using the correct one; the one you want is in the C:\Windows\SystemWow64 folder.

  There is a 32 bit and 64 bit version of the 32 bit ODBC manager program.  See:

http://support.microsoft.com/kb/942976

Jim.
0
 
tommym121Author Commented:
Thank you very mucfh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.