[MS_AccessPros] A better way to import data?

 

I am building a database and the users are sending me information in raw form.  Basically name, email address, "Tag". I have 2 tables

ContactTBL

• ID
• FirstName
• LastName
• Tag

EmailTBL:

• ID
• ContactTBL.ID
• Email

Because the EmailTBL uses ContactTBL.ID, I have to jump through a couple of hoops to get this value and then load ContactTBL.ID & Email values to EmailTBL.

Is there some magical way I can import to both tables at the same time?

Thanks

__._,_.___

---

Posted by: jan.hertzsch@gmail.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___