Append in two table

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

Guest

Hi all,
How can I append data in two related tables simultaneously?
any help/suggestion would be appreciate
 
Hi all,
How can I append data in two related tables simultaneously?
any help/suggestion would be appreciate
Click to expand...

A single Append query can only update one table, but you can call two
Append queries in sequence from a macro or (better) from VBA code.

What exactly are you trying to accomplish?

John W. Vinson [MVP]
 

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

Appending data to linked tables 5
Appending to normalized split tables 2
Append Query Issue 0
getting an autonumber field to go beyond 3999 5
Append Only 6
Append tables 1
Access Macro Repeat Expression using value of a field in table 0
Run multiple queries 3

Back
Top