Hi - I'm new to all of this (creating ODBC databases & TechNet) and need some help please!

I've tried creating an ODBC database to link some data between Excel and Visio Pro but seem to be missing the current Excel driver. My problem is that in the Administrator Tool's ODBC Data Source Administrator 32-bit - the only available Excel drivers are for .xls files. I tried to update my copy of Office 365 and Excel 2013 but the update checker says I'm all up to date. Could someone please tell me where I can download the Excel driver for .xlsx to create an ODBC database? Otherwise when I use the the .xls driver to create the ODBC database and link it up to Visio (using the outdated format of .xls for my Excel file), the Excel file eventually gets corrupted and I can't access it anymore. 

The only information I found potentially helpful online is the 2007 Office System Driver (https://www.microsoft.com/en-us/download/details.aspx?id=23734) but I don't know if it will help me given that I'm running Windows 8.1 and have Office 365 (Excel 2013 and Visio Professional 2013). 

Please advise! 

• Edited by jessica.chen 8 hours 42 minutes ago

Hi jessica.chen,

Could you tell me which version of Windows system and Office are you using? 64bit or 32bit? Did you get any error messages?

Based on your description, it seems that the ODBC Driver is not available for your excel.

As far as I know when the 32-bit version of Office or the 32-bit Office System Drivers are installed on a 64-bit version of Windows the driver is unable to use. This is a known issue in Office and you could refer to this thread:

http://answers.microsoft.com/en-us/office/forum/office_2007-excel/no-odbc-drivers-available-for-excel-or-access-in/001c234b-dfd5-4378-a325-c4f1482fb6fd?auth=1

You can check if these answers are work for you. To locate the 32-bit Office System drivers, use the appropriate version of the ODBC Administrator tool.  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.  

And you can also refer to this KB article to get more information:

https://support.microsoft.com/en-us/kb/2721825/en-us

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su