What about SCATTER and GATHER?

Select Table1
scatter name oRec2copy
select Table2
append blank
gather name oRec2copy

OR 

Select Table1
scatter to aRec2copy
insert into Table2 from array aRec2copy

>Hi All,
>
>Looking for alternatives: given two tables with the same fields structure what is the fastest way to copy a single record from one file to another?
>
>Thanks