Adding old Data to new DB

[tl mike]

I am stumped on how to move the data from an old data base to my new one for this example it is the Copy, because the PK will change when added.

I have 2 tbls
that one is the tblBikeModelIDs in which it takes form 2 other tables for year and make.

Then I have tblModelIDKits which it is the details table that combines the the tblbikeModelIds and tblPartNumber.

 

[Banana]

If it's going to be a one time thing, then a quick'n'solution will do- Create a VBA procedure that loops through the main table one record at a time, then do a look up in each child table, then updates the new database with that record, gets the new PK, then add the new child records related to that recently added record with that new PK. Lather then rinse. Repeat as necessary.