![query in transcad query in transcad](http://docplayer.net/docs-images/50/15116097/images/page_9.jpg)
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. 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 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.
![query in transcad query in transcad](https://d3i71xaburhd42.cloudfront.net/e27526933aa035ff3120a925377c8bef024b887f/3-Figure2-1.png)
I'm running a 64-bit Windows system and 32-bit Office. If you have feedback for TechNet Support, Emi, Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help.
![query in transcad query in transcad](https://ars.els-cdn.com/content/image/1-s2.0-S0198971598000039-gr1.gif)
Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office You must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe.Īnd you can also refer to this KB article to get more information:Ĭonfiguration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. If you build and then run an application as a 32-bit application on a 64-bit operating system, To locate the 32-bit Office System drivers, use the appropriate version of the ODBC Administrator tool. You can check if these answers are work for you. This is a known issue in Office and you could refer to this thread:
#Query in transcad drivers
The only information I found potentially helpful online is the 2007 Office System Driver () but I don't know if it will help me given that I'm running Windows 8.1 and have Office 365 (Excel 2013Ĭould you tell me which version of Windows system and Office are you using? 64bit or 32bit? Did you get any error messages?īased on your description, it seems that the ODBC Driver is not available for your excel.Īs far as I know when the 32-bit version of Office or the 32-bit Office System Drivers are installed on a 64-bit version of Windows the driver is unable to use. xls for my Excel file), the Excel file eventually gets corrupted and I can't access it anymore. xlsĭriver to create the ODBC database and link it up to Visio (using the outdated format of. xlsx to create an ODBC database? Otherwise when I use the the. Could someone please tell me where I can download the Excel driver for.
#Query in transcad update
I tried to update my copy of Office 365 and Excel 2013 but the update checker says I'm all up to date. My problem is that in the Administrator Tool's ODBC Data Source Administrator 32-bit - the only available Excel drivers areįor. 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. Hi - I'm new to all of this (creating ODBC databases & TechNet) and need some help please!