combine two tables with same fields

J

JR

I am trying to merge two tables that have the same field
names and properties, different sets of data in the
records, and a total of 84,309 records (48065 and 36244).

I've been trying for a while, cannot get anywhere.

Any clues?

Thanks!
JR
 
R

Rick Brandt

JR said:
I am trying to merge two tables that have the same field
names and properties, different sets of data in the
records, and a total of 84,309 records (48065 and 36244).

I've been trying for a while, cannot get anywhere.

Do you mean temporarily as in a query or permanently so one of the tables
can be eliminated?

For the former use a UNION query. For the latter use an Append query to
copy all records from one table into the other.
 

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

Top