Merging to table into one

[Jason frazer]

I have two tables that are the same except for 3 thing.
Table #2 has different data in three fields than Table #1.
There is about 75 fields in each table. The tables have
all the same field names. I want to replace the data in
three fields ("Actue Toxicity" "Irritation" "other Acute")
with the data in three field ("Actue
Toxicity" "Irritation" "other Acute") in Table #2 and save
this as a table #3 not a query.

Thanks for your help

 

[Cal]

Create a query linking the wanted data and then change
the query type to MAKE TABLE.
This should create the third table as you want it.

good luck,