Merge data from two tables into one table.

[deintinis]

I have two tables in an Access database. The tables are virtually identical with a few differences. I am trying to get the data from one of the tables imported into the other table.
Does anyone know the easiest way to go about this. Do I have to export to excel and reimport from excel or is their some code that I can use to pull the records from one table to the other.

Thanks

 

[p27br]

Use an append query to append all common fields from one table to the other, then delete the unnecessary table