"Merging" tables

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

I get monthly information updates that I am able to import
into a DB. This information is in the same format all of
the time. I have gotten the information into a new table
in the DB and would like to know if I can "merge" the two
tables together. Both tables have the same field names and
have many of the same records. Life would be a little
easier if I could merge them together and have all of the
information in the same table. Is that possible and if so,
how?
 
To permanently merge the records, use an append query to append records from
one table into the other. If they don't have to be in the same table, you
could use a union query.
 
I get monthly information updates that I am able to import
into a DB. This information is in the same format all of
the time. I have gotten the information into a new table
in the DB and would like to know if I can "merge" the two
tables together. Both tables have the same field names and
have many of the same records. Life would be a little
easier if I could merge them together and have all of the
information in the same table. Is that possible and if so,
how?
Click to expand...

Possible, and downright easy. See the online help for "Append Query".
 
Back
Top