Transact SQL :: Load 2 Tables With Data From 1 Inventory?

To setup some data in some new tables in t-sql 2012, I need to create a relationship between 2 tables were data is obtained from an inventory file. The inventory file will be loaded to sql server 2012 from an excel spreadsheet.

1. Columns that will be loaded to the first table are:

1. Inventory category number,
2. Inventory date,
3. Inventory Category total amount, and
4. Inventory category quantity on hand.

This table will have a column called Item number. This will need to be the value of item number that is in the second table.

2. Columns that will be loaded to the second table are:

1. Item Number,
2. item date,
3. Item price, Item quantity on hand.

Thus can you show me the sql that will load the table into both tables? This sql would also need to show how to obtain the values of item number from the second table and place that value into the first table.