How do I import specific entries from one table to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main address book, and I would like to import or create another
table for a Christmas mailing list, using some of the entries from the
address book. How do I import or transfer only selected entries from the
main address book to the new Christmas mailing list??
 
Is your "main address book" an Access database?

I have a main address book, and I would like to import or create another
table for a Christmas mailing list, using some of the entries from the
address book. How do I import or transfer only selected entries from the
main address book to the new Christmas mailing list??
Click to expand...
 
Probably you don't need to create another table. How about adding a
Yes/No field called XmasMail or some such to the existing table. Then
you can just go throug the table checking this field in the records you
want on your Christmas list.

Then create a query whose source is the main table, with a criterion of
True or -1 in the XmasMail field; this will return only the Christmas
list.
 
I will try it and see if it works. I will add a Yes/NO field to the Address
Table and go from there..

Thanks John
Brian Watson
 
Back
Top