>>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.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.