Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Wednesday, August 5, 2015 10:04 PM
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.
https://support.microsoft.com/en-us/kb/2721825/en-us
All replies (5)
Friday, August 7, 2015 1:52 AM
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
Friday, August 7, 2015 9:02 PM
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?
Saturday, August 8, 2015 10:01 AM | 1 vote
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.
Sunday, August 9, 2015 8:43 PM
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!
Monday, August 10, 2015 2:28 AM
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. ▼-▼