How to import a file into database and split into two related tables
I have an MS Excel file in which I have keep purchases, i.e., inventory. I want to import this file into Access and split it into two tables. I want one table to have a description of the item and where purchased. I want the related (linked) table to have purchase date, cost , etc. That way I can keep one record for the inventory item and display multiple purchases through a subform. How can I split the record on import?
Note: I am using Accessl 2016 and know how to import files from Excel to Access but don't know how to split the records.
Thank you, Judy