No ODBC Drivers available for Excel or Access in Windows 7 ?!

Anonymous

No ODBC Drivers available for Excel or Access! Even after a complete new installation of Windows 7 and Office 2003 professional or Office 2007 professional on another computer. When I want 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!

How to install these ODBC Drivers or how to go about it? Thanks a lot for your responses!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

I think the answer is already here in this thread (but it's not, imo, the post marked as "Answer").

You need to use Windows 7 32-bit subsystem. In particular, you need to use the ODBC control panel here:

c:\windows\sysWOW64\odbcad32.exe

At least in my case, that version (the 32 bit version) of the cpl did contain the Access (2003 in my case) ODBC driver.

The 64 bit DLLs etc are in c:\windows\system32. The 32 bit subsystem (so you can still run 32 bit apps on 64 bit Windows 7) is in c:\windows\sysWOW64.

I mean, that's very intuitive - right?

But I didn't post anything here until I could confirm that the 32 bit ODBC connection to Access was working (giving me the db's data).

Well what I'm trying to get to work goes through a bunch more complications: https://sourceforge.net/projects/mondrian/. Tomcat, mondrian, edits to config files to point things in the right direction, etc.

But given that it all now works, I'd say that the ODBC connection to the Access db must be working (I'm getting its data in the web interface to Mondrian). Mondrian is an open-source (sourceforge) OLAP project. It's also bundled with other BI stuff at: www.pentaho.com

The default data store for Mondrian on Windows is Access.

So the key is to use c:\windows\sysWOW64\odbcad32.exe

0 comments

Answer accepted by question author

Anonymous

The following KB article provides additional information on how to create DSNs that make use of Office ODBC drivers on 64 bit versions of Windows.

2721825 Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows

http://support.microsoft.com/kb/2721825/EN-US

Hopefully this helps.

Best Regards,

Nathan O.

Microsoft Online Community Support

0 comments

83 additional answers

Anonymous

2010-02-08T01:50:20+00:00

I also have need to use the ACCESS 2007 ODBC connection (using Sunbelt-plb PLBWIN application). I upgraded to Windows 7 and no where is the driver to be found. I also tried your proposed solution with no luck. Where you able to install the Access 2007 ODBC driver?
Was this answer helpful?

0 comments No comments
Anonymous

2010-02-01T14:01:29+00:00

Apparently you have misread the order of the steps you took to do this. I as well as another person on this forum found that the Properties selection was unavailable after "run as Administrator" and even after trying a variety of permutations the driver list you described was unavailable.

We would much appreciate a revision of your instructions so that we could achieve your results.

I very much want to create an ODBC connection to an ACCESS 2007 DB from a VB 200 app running on 64 bit Windows 7. If anyone can help me accomplish this I would be very grateful.

Thanks,

Revilorb
Was this answer helpful?

0 comments No comments
Anonymous

2010-01-25T17:50:04+00:00

Could you walk through your own instructions and verify the order? When you right-click on the Data Sources icon and Run as Admin, there is no PROPERTIES button to select.
Was this answer helpful?

0 comments No comments