When a user tries to join two tables (one from Oracle and the other from Excel) the following error occurs:
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] You cannot use ODBC to import from, export to, or link an external Microsoft Office Assess database table to your database.
Ignore error and continue execution?
He clicks on Yes and nothing happens.
SOLUTION 1:
Issue has been addressed and fixed in Toad for Data Analysis 1.1.0.473:
1. Download Toad for Data Analysis 1.1.0.473.
2. Un-install the previous version of Toad for Data Analysis.
3. Manually delete the Toad for Data Analysis folders in the following folders:
* ..\Program Files\Quest Software
* ..\Documents and Settings\<User>\Local Settings\Application Data\Quest Software
4. Install Toad for Data Analysis 1.1.0.473 with default settings.
SOLUTION 2:
If using an the Excel database connection append the dollar sign ($) at the end of the Spreadsheet file name.
i.e. ExcelFile$.xls
(See screen shot for Toad Tip).
