Append in two table

B

bijan

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

John W. Vinson

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]
 
B

bijan

Thank you John
As you recommend , I perforned it with two append queries via vba
Bijan
 
Top