Duplicating a record

Originally posted by : Anders (anders@peach.se)Hi!I have a problem that is kindof tricky...Im trying to copy a record from a recordset and then insert it again as a new record with a new primarykey value - with other words duplicating a record....Does anyone know how to succeed?Please help me if you know..I really need to make it work!!!Regards Anders

SELECT @MyID, x1, x2, x3 INTO MyTable FROM MyTable WHERE ID = MyOldID