Append & update table from another daily

[Moore71]

Hi guys,i need to know the best way to append,table1=productid,ProductName,Qty to table2=Productid,productName,Qty,date daily
I want to be able to append Records daily from table1 into table2 OnClose.But i do not want duplication of record in the same day.
If changes occurs in table1 after append,table2 should be updated using If conditions
Thanks in advance

 

[plog]

Why? Generally moving data among tables is a sign of poor structure. Why do you have 2 similar tables?