>I am presently working on an application that requires a 200,000 record " delimited file into VFP. I am using Append from to do this. But I have heard that Insert - SQL works better and faster. The only example I can find shows how to do it with a single record. Is there a way to do it with multiple records?
>
>Thanks,
>
>Bill Chadbourne
>wchad@ime.net
Bill,
APPEND FROM is the best way for your needs. You might try deleting the CDX file on teh DBF with a DELETE TAG ALL before the append and then INDEX ON after it to recreated those index tags. This is sometimes faster with large appends than appending with the indexes.