Import a general database into contact management database

[Busy in Paradise]

I have created a general database in Access for mass mailings, with just
name, address, city, state & zip codes. I now want to import that
information into a Contact Management database, so when I pull up a
customer's "card", it will show me all of their pertinent information -
names, address, phone numbers, birthdays, childrens' names, etc. How can I
import the original database information without having to type each customer
separately into the contact management database? Thank you.

 

[Larry Linson]

Link the Tables (File | Get External Data) then use them to create Append
Queries to copy the information to the Tables in the Contact Management
database. You can import any other pertinent objects, such as Forms,
Reports, Macros, or Modules, using the same (File | Get External Data)
operations.

Larry Linson
Microsoft Access MVP

 

[Busy in Paradise]

Thank you, Larry. Your response was very helpful. I am quite new to Access,
and am slowly learning how to use this great tool. It took me a couple of
hours to figure out how to create an Append Query, but I did it! Thank you,
again.

Diane