How to add data from one table to another table via query

[netrusher]

I have a query question. I have a Table named tblAllParts1. I want to update this table from another
imported table named tblReqdParts. There are two fields in both tables:
tblAllParts1
Part
Required1

tblReqdParts1
Part
Required

My issue is how can I get the data from tblReqdParts1 into tblAllParts1 via a query. The two field names
Required1 and Required are different. If I do a make table the field names will not be correct for
tblAllParts1, this table is in another query and since it gets deleted and recreated the other query loses
the link.

 

[netrusher]

I need to remove all existing data from tblAllParts1
before adding the data from tblReqdParts1

 

[netrusher]

I just found out that delete query only deletes records so I can do a delete query and then an append query. Thanks again!