Importing Data from Excel

[millertimecu32]

I am trying to import an excel sheet into Access. The data that is in the excel table is going to go into 3 different tables. Two of the tables are a one to many relationship to the 3rd table. They are joined by primary keys and lookup tables. My question is how can i import the data into access and append the data to all 3 tables so that the lookup tables are automatically populated?

 

[FoFa]

Import into a "work" table.
Run queries to update the related tables as appropriate.