I am trying to load a table where it only loads the rows from a .xls file that has a column that matches another column in a different .mdb table. Normally I feel I could easily do this with an SQL WHERE EXISTS statement. But I am running into the error "External table is not in the expected format". I suspect an issue with loading the data with ODBC driver.

Thanks for replying. Both the excel file and the access database are not password protected. The error message is also in reference to the ODBC Excel Driver. I know you do not need a driver to load .xls files but I did so I could edit the load in SQL.

The problem is then that I only want to pull the rows from the excel file that have an existing PlayerID in the Access Database Table. Which is why I figured I need the WHERE EXISTS SQL clause so as to reference the other table in a subquery.

I apologize that is not working so I must not be explaining things incorrectly.

AccessDatabaseTable:

Load

PlayerID

;

SQL SELECT from 'YourDBTable';

ExcelFileTable:

Load

PlayID

From YourExcelFile.xlsx

where exists(PlayerID);

That variable is different. In the access database there are multiple instances of those ID's but the range is smaller (ie 1-20 but multiple for each), whereas the excel file (PlayID) is a unique key with a larger range (1-75 but I only want the information for 1-20) .