I have been sent an excel file that contains data from two tables. The execl file contains a tab for each table. One column in one of the tabs has the references to the other table. So I guess the original database has three tables. The third table being all the joins between the other two.
Is there a way to import the excel file so that it creates both the tables but the "third" table with the joins?