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

Anonymous
2009-10-08T06:27:39+00:00

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!

Microsoft 365 and Office | Excel | For home | Windows

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
2010-02-16T06:07:57+00:00

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

Was this answer helpful?

90+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2012-07-03T21:51:52+00:00

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

Was this answer helpful?

30+ people found this answer helpful.
0 comments

83 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-28T01:15:31+00:00

    Gary,

    After hours of searching for a resolution, I stubbled upon this chain.

    You are spot on.

    Load the Microsoft Access Database Engine 2010 Redistributable,

    Install the 32bit version, and off you go.

    I had been running Win7 and had to poke around when MS decided to remove the ODBC drivers from the main group.

    Now running Win8 and without your help would still be searching after 4+ hours for a solution.

    Thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-07-09T23:02:55+00:00

    Same turmoil,

    My solution was two days of reading every post I could to finally realize... that a lot of misdirection is going on in this thread. Using the c:\windows\sysWOW64\odbcad32.exe path as often mentioned gives no joy.

    My scenario:

    Using Windows 8.1, running Access 2013 and trying to connect to a web based .accdb file.

    Already have the IIS configured (Internet Information Services). You may need to turn that on too through the Control Panel - Administrative Tools - Programs and Features

    Neither the 32-bit or 64-bit managers under control panel have the correct driver... you see only drivers for the older extension .mdb....

    Solution, download:

    Microsoft Access Database Engine 2010 Redistributable

    When you install this engine, you will then see the (mdb, .accdb) driver listed in both of the ODBC managers.

    Search for this and it will pop up as a 32 and 64 bit version. I downloaded both. Not sure but you may only need the 32 bit drivers for ACCESS

    As I thought everything on my new laptop was 64 bit, I loaded the 64 bit version first. Turns out, Access could use the 64 bit driver to connect to the web but all that came back were the headers and table structure, no data... so after searching for errors in code I had a hmmm moment.

    First you have to delete those 64 bit connections then DELETE the 64bit MS Access DB Engine 2010 ReDist... from your program files and then load the 32 bit version.

    When I recreated the connections using 32 bit drivers, data loaded.

    Knowing what I know now, I would have loaded the 32 bit to start with.

    Apparently if everything in the stream is not 64bit, (like the server) the 64 bit drivers will not work 'completely'.

    Hope this helps someone.

    Was this answer helpful?

    0 comments