Well, i have solve the first problem earlier. Hmm, i actually missed the import objects function.
now the 2nd problem. Each time i append, the primary key violation will come out. ok, my database detail is as follow:
table - EmpTable -> EmpID (primary key), EmpName, Address
EmpTable1 -> EmpID (primary key), EmpName, Address
the EmpID is not an autonumber, which means the data is entered by user. So, each time i try to append both tables, that error will come up.
hope this information helps.