ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] You cannot use ODBC to import from, export to, or link an external Microsoft Office Access or ISAM database table to your database.
I’m not using Microsoft Access data, but there is a connection in the Access Source to Toad Sample Database.mdb. I didn’t connect to this database (it automatically connects).
I’m using Toad for Data Analysis 2.1.0
I’m trying to compare Excel data with Oracle data. I created an ODBC link to the Excel data and am able to read each set of data separately. When I create a link in the query builder between Excel and Oracle and run the query, I receive the following error: