>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

Jos,

Haven't tested it, but I would expect that

INSERT INTO Table2(Field1, Field2) Values (Table1.Field1, Table1.Field2)

would be the fastest.
Regards,