>"APPEND FROM" will work fine. I was not aware of that statement. My FoxPro is very rusty.
>
>Using the COPY FROM and the original table is 41,700kb. The copy statement takes several minutes. Is there anyway to speed it up?
>
>Brenda

SELECT - SQL will provide the fastest. If all the records you need are together [i.e., you have an index on CustNum for every table], you can --

seek nCustNum
copy to test_table1 while CustNum = nCustNum