Code to import flat file from Excel to Access then split into related tables.

I need to get excel data into access. Once in access columns from the excel data have to be split off and appended to the fields of separate access tables. these tables are related and so correct key values will be required to maintain the relationship.