Missing ODBC Data Source Excel Driver for .xlsx

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! 



June 29th, 2015 10:40pm

Hi Emi,

Thanks for your reply. I'm running a 64-bit Windows system and 32-bit Office. I don't get any error messages, aside from the one I get eventually on the Excel 97-2003 file (.xls) that I'm currently using for my ODBC database. The error message there says the file is corrupted and can't be accessed and it happens after I've created the ODBC database and used it less than 10 times. 

I followed your instructions and found the 32-bit Office System driver in the SysWOW64 folder but the driver for Excel 2013 file (.xlsx) is also missing in there. So the only ODBC data source I can build with Excel is with the outdated .xls file, which will eventually get corrupted after a few usages.

Also I checked out both articles you listed and tried the advice listed there with no luck. I tried changing the permissions on the ODBC Data Source Administrator tool and could only do so for the tool located in the administrator tools, not the SysWOW64 one. Even then, that didn't miraculously free up the Excel 2013 driver as it is still missing from both ODBC Data Source Administrator tools.

Can I install new ODBC drivers? The .xlsx compatible one? According to the ODBC Data Source Administrator tool (from the SysWOW64 folder, not the administrator tools), under the Drivers tab, it says "To install new drivers, use the driver's setup program." Where is the driver's setup program? 

Please advise, thank you!

Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2015 6:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics