append query

mithani

Registered User.
Local time
Tomorrow, 05:33
Joined
May 11, 2007
Messages
291
Hi everyone,

What I am looking for is:

Scenario 1
1. Append all records from Table 1 to Table 2.
2. Whenever any record add/edit/delete inTable 1, Table 2 should automatically upate.

Scenario 2
1. How would I append all records from Table 1 to Table 2 where both tables structure are different. Table 1 is a MYOB table and Table 2 is a access database table.
2. What if I need to append selected data from Table 1 to Table 2. Let's say all data between such date.

I appreciate your help.
mithani
 

Users who are viewing this thread

Back
Top Bottom