Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is my problem here?
I really appreciate you being patient with me. Got it to work, Thanks.