 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / November 2005How do I import specific entries from one table to another?
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?? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. Yes, all the info is in Access. > Is your "main address book" an Access database? > [quoted text clipped - 7 lines] > > Please respond in the newgroup and not by email. 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. >Yes, all the info is in Access. > [quoted text clipped - 9 lines] >> >> Please respond in the newgroup and not by email. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. 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 > 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 [quoted text clipped - 23 lines] > > Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.