Hi,
I tried using the 32-bit Office System driver (ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe) to build an ODBC data source but the Excel driver for .xlsx files is missing. I looked in the regular System Administrator's ODBC Data Source Administration and even the 64-bit version - and they are also missing the current Excel driver.
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 (since that's the only Excel driver available in the all 3 available ODBC Administrator tools). 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've already tried the information in the following threads without any luck:
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
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 help, thanks!