Combine two linked tables and a lookup table

I am pretty new in Access so my apologies if my if this topic is already covered. I have two sets of data in excel in separate workbooks both with the same headings in the same order. both works books are updated and saved weekly and they both have been brought through Access via importing a linked table. The first thing I do not know how to do is I need to take those two tables and put them into a master table and then I have a 3rd table that lives in Access and this table has a column called ORG and a column called UCODE for each ORG there is unique UCODE in my two other tables they have a column with the ORG in it and I need the query two basically combine the two tables and then add the UCODE based on what the ORG is how can I achieve this result. I tried a union query and got the two tables into one but now I do not know how to get that third table in the mix. Also If I update the data in the Excel sheets will it automatically update the union query?

In a macro,
Run a query to empty the target table,
Import table 1 to master,
Import table 2 to master
Run query to join the 3rd table to the master table. This query will join fields on the common field.

No, it will not update the excel sheets. You'd have to export the data back to the workbook.

Originally Posted by ranman256

In a macro,
Run a query to empty the target table,
Import table 1 to master,
Import table 2 to master
Run query to join the 3rd table to the master table. This query will join fields on the common field.

No, it will not update the excel sheets. You'd have to export the data back to the workbook.

Thank you! That worked and then later I realized I could use that union query and my lookup tables and just do a select query with multiple table to get the results I needed. Thanks again!!!

, you'd import all fields, then do what you need with them.

I cannot reply to your private messages because your box is full.