How can I merge two databases?

[Guest]

I have one database that has First, Last, address, Email, ect. I have
another database that has email and our mailing list location. I want to
combine the two so that list with only the email and mailing list is replced
with the one that has all the contact information. When I am done I should
have all the contact information and the mailing list info. Thank you for
any help

 

[Guest]

Sorry what I ment to say is I have 2 tables.

 

[John W. Vinson]

I have one database that has First, Last, address, Email, ect. I have
another database that has email and our mailing list location. I want to
combine the two so that list with only the email and mailing list is replced
with the one that has all the contact information. When I am done I should
have all the contact information and the mailing list info. Thank you for
any help

Create a new table with all of the fields that you need, and run two Append
queries.

Are there duplicate records, i.e. the same person represented in both tables?
If so do you have a *reliable* way to identify the duplicates - a primary key
which uniquely identifies the person? If not you may have difficulties: names
and addresses are not reliable as unique identifiers.

John W. Vinson [MVP]