How to merge 2 identical tables ?

W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relationships 1
Union Query??? 1
Need to Merge 2 identical databases - with problems.... 6
Merge 2 tables into 1 1
COMBINE TABLES IN ACCESS 3
Moving data between tables 1
Adding New records in multiple tables 2
Go To Record 1

Top