doing an append and an update at the same time

  • Thread starter Thread starter Helen Martin
  • Start date Start date
H

Helen Martin

hello.. I'm trying to import some new names and email addresses into my
contact database..

I need to add records to my mail contact information table, and add
records to my table which shows the relationship between the contacts
and the organisation..

I need to know if I need to do this in two steps or if there is some way
to do it in one pass...

is there any way to add records to two different tables in one operation..

can you "append" to a query??

Helen
 
just realised this subject is wrong but if I change it the messages
won't thread properly.. :)

its not really an update and an append, but two append procedures..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
key violation in append query 2
Append to two different tables 23
Make one final list from four sources 1
Append Queries 5
appending new records to a table with a compound primary key 9
Preventing duplicate entries with an Append Query 3
Batching Append Queries 5

Back
Top