Hello Mahmood

have you looked at the "append from" command

I think if you SQL your data to a local table with the same data types and data lenghts it is a snap



>Hi All:
> I want to move large number of records from one table to another table. Right now I am using Scatter Gather and insert commands to accomplish this task. However, insert command takes one record at a time. Thus, I tried using the Select Statement. The selecte statement also takes a while to select the records. Is there a functions in VFP like 'Bluk copy' in SQL that will allow me to move chunck of data from one table into another table in a short time?
>Thanks
>MA