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 Monday, June 29, 2015 10:46 PM