>>>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,
>
>Thanks Jim. I've decided to stick with the SCATTER variations because its also easier coding :) Thanks for the suggestion.

This is true, particularly with a long field list.