10 Replies Latest reply: Jul 12, 2017 3:35 PM by Joseph Bajo RSS

    Loading Data

    Joseph Bajo

      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?