Automation not copying records

I have 2 tables; Table 1:  Products (about 500 records) Table 2: Daily product valuations This is what I am trying to accomplish: 1) Copy all the products from table 1 to table 2, every ...