How to merge 2 identical tables ?

[Will]

I have two identical tables... all fields are the same...

tblOne
id
name
city
state

tblTwo
id
name
city
state

I want to merge the data into a single table.
Both tables are in the same access database.

How do you do this?

thanks for any help.

 

[Guest]

Hi Will -- Use an Append Query...