Hi,

I've tried everything I can think of and find online (see below) about this subject to no avail. Please help! 

My Windows 8.1 Surface Pro 3 does not have the .xlsx ODBC driver, even when I look it up in %windir%\SysWOW64\odbcad32.exe. It only has the driver for .xls, which will eventually corrupt the .xls file used for the database after a few uses.  

On the Drivers tab in the ODBC Data Source Administrator, it says: "To install new drivers, use the driver's setup program."

Where is this driver setup program and where can I download the .xlsx driver? 

Also, I just reformatted and started over again, re-installing Office 365 (includes Access) and everything else. It's a 64-bit Windows system and 32-bit Office. 

Please advise! Thanks!

--

I've already tried the advice listed in the links below without any success. 

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

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

Maybe the ODBC drive version does not match the Excel version. To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN.

Please read this article: http://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx

Thanks for the response.

I tried that already (c:\windows\sysWOW64\odbcad32.exe) and that ODBC Data Source Administrator does not have the .xlsx driver, just the .xls one. 

The article you provided states at the top: "After you have installed an ODBC driver from the driver's setup program...." Do you know where I can find the driver's setup program and the .xlsx compatible driver? 

I tried that already (c:\windows\sysWOW64\odbcad32.exe) and that ODBC Data Source Administrator does not have the .xlsx driver, just the .xls one.

Hmm... on my system this driver has capability for such files:

Have you tried to install the Microsoft Access Database Engine 2010 Redistributable?

https://www.microsoft.com/en-US/download/details.aspx?id=13255

Andreas.

My ODBC Data Source Administrator (32-bit) also shows that supposedly has the .xlsx driver on the User DSN tab. The problem is when I click on Add and the drivers available for Excel are only for .xls files, not .xlsx files.

Regarding the https://www.microsoft.com/en-US/download/details.aspx?id=13255 article-

No, I have not tried installing the Microsoft Access Database Engine 2010 Redistributable. Will that help even though I'm working with Excel 2013? Also, I'm not sure how to do the listed install instruction #4 (If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file). 

I'm trying to create an ODBC database to link data between Excel 2013 and Visio Professional 2013.  

Do I need to set the Connection String for my purposes? If so, how do I do that? 

Thanks!

Feel like you have tried a lot of general methods to solve this issue. Did you try to reinstall your computer? As the DRIVER is more related with Windows system. This is the last resort I know. -