Can I merge two existing Access tables together in Access?

N

Nicole

I have two seperate tables in Access (for example a complete catalog listing
of courses and then a new table with just new catalog course changes) and I
would like to know if there is a way to merge those two tables together to
make one complete table? The second table was not added to the original
table because we did want the information separate so we know that we got it
all, but we also thought we would be able to merge the two tables to make one
complete one? Is this possible?
 
J

Jeff Boyce

Nicole

Link to (or import) both tables in one .mdb file.

Create an append query from the new table to the complete listing table. If
you have any unique indexes on the complete listing table (including a
primary key), you won't be able to add duplicates.

By the way, there's no need to use a separate table for "new" records. You
could include a DateEntered field and keep track of when you started on
"new" records. Use a query to pull the new records, by DateEntered > some
date. Or you could include a Yes/No "flag" field and "flag" the new
records, until you were done considering them new, then uncheck that field
so you could start on the next batch of "new" listings.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
S

SusanV

Are the 2 tables the same as to fields and structure? If so, use an append
query to add the records from the second to the first (or to add the records
from both to a whole new table)

As always, make a backup copy of your db first!
 
K

kul

I found myself having a similar question with Nicole. Hope you can help.

I have a table (donor table with donors' info) with 1-to-many relationship
to a giving history table. I have been updating those tables.

For some reason, I have got another workmate who has the exactly same set of
tables at her computer and doing the same thing as me. Just she is updating
those giving history which I don't have in my table. Now, if I want to merge
those tables together (coz she has added new names at the donor table). That
is, the donor table combing with another donor table (I believe there should
be duplicates) and giving history table merges with another giving history
table (there shouldn't be duplicates on the date and amount according to the
donors thou).

What should I do?

Thanks.
kul
 
Top