>Is it faster to use insert-sql to copy records from one table to another? If so, how do you use insert to move multiple records?
>
>Thanks in Advance,
>
>Bill Chadbourne
>wchad@ime.net

I do not know if it is faster or not but the VFP SQL would be

Insert into Mytable from ArrayName

So all records have to be copied from the source table to an array first then inserted into the target table. I forget which one only locks file header versus locking the entire file (shared file use), either inserting records or appending from.