ODBC error when attempting an inner join between an Oracle table and Excel file (4306736)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

ODBC error when attempting an inner join between an Oracle table and Excel file
Description

Running a heterogeneous query between an Oracle table and an Excel document results in following error:

"ERROR [HY00][Microsoft][ODBC Access Driver]You cannot use ODBC to import from, export to, or link an External Microsoft Jet or ISAM database table to your database."
Resolution

WORKAROUND

None

STATUS

Waiting for fix in future release of Toad for Data Analysis
Defect ID

CR0224965

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title