database merge

S

sweet1rao

I have several databases that I would like to merge into one for a
mailing......any suggestions on how to do this?
 
M

[MVP] S.Clark

If you are referring to two tables, then data can be merged with a Union
query. See the help file for more information.
 
J

John Vinson

I have several databases that I would like to merge into one for a
mailing......any suggestions on how to do this?
Click to expand...

Well... this can be very easy, or extremely difficult, depending on
the nature of the databases. One table in each .mdb file? or 83 in one
and 92 in the other? Autonumbers? Multiple linked tables?

If you have two tables of names and addresses, a simple Append query
will work; or you can even use a UNION query (see the online help) to
temporarily combine the data in the two tables without affecting
what's stored.

Please post a bit more detail. This is certainly doable, but the
details matter!

John W. Vinson[MVP]
 
Top