I am ready to insert data from the old db into the new db. I know that I should use a query. I am thinking that I would simply use a “select” statement selecting each field of the old table that I want and then use an “Insert Into” each field of the new table where I want the info to go to.
I will have to select data from the tables “Tool List”, “Inspection Log” and “Dimension Verification” of the old db and Insert Into the tables “tblTools”, “tblInspections” and “tblDimensionVerification”
of the new db.
These are the only tables that I will have to deal with because the project in the old db never went that far in development.
Do I do all three tables at the same time? Or start with the “Tool List” & “tblTools” and then do the other tables one at a time?
It looks like I will have to write out long hand the SQL as the query wizard doesn’t seem to cover this.