Quote Originally Posted by mendhak
You can run a few simple SQL statements to do this.

INSERT INTO Table2(field1,field2,field3,field4)
SELECT T1.field1,T1.field2,T1.field3,T1.field4 FROM Table1 T1 WHERE T1.field1 = 29385

Then,

DELETE FROM Table1 WHERE T1.field1 = 29385

HTH
awesome reply, perfect.