I am trying to set up a new connection to a csv file using the Transform tool. When I attempt to create the connection, Toad throws the the error: "Toad Data Point 4.0 is a 32-bit application. The 32-bit version of Microsoft Excel is required for compatibility with this feature..." But I DO have 32-bit Office 2016 installed. Any idea why this is happening?
MS Office: Office 2016 Standard (v16)
Toad: 4.0.0.163
OS: Windows 10 Pro 64-bit
The error message is confusing. We have changed this message in TDP 4.0.1. It usually means that you have Excel 2016 or Office 365. These two versions do not ship the ODBC driver needed to connect to csv or excel. Press on the hyperlink in the message and install the 32-bit access engine. This will resolve the issue
I followed the link and installed the 32-bit access engine, rebooted, but am still getting that error. I’m also not able to see the 4.0.1 update. Is there a way to manually check for updates from within the app?
can you turn on logging and send post the Toad.log file from App data dir? Also send ExecutionTrace.log
…Toad.exe /log=all
Here are the logs.
Toad.zip (17.1 KB)
I can’t tell from those files what the issue is. Let’s try an make an ODBC connection like we are doing under the hood. Follow these steps:
File | New| Connection.
Chose Generic ODBC
Click on the ODBC Manager icon on the right of Data Source Name
Cick Add and choose the Microsoft Access Text Driver
Give it a name an choose directory where the csv file is located. (Make sure the file has extension of *.csv or *.txt)
Click OKay to close ODBC Manager.
Chose the DSN you just created and click okay to connect.
Do we see any information errors?
After updating to the latest version of toad, the issue seems to have resolved itself. Thanks for your help.
Good to know:)
