> 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? INSERT INTO will insert multiple records, but only if you're inserting from an array. And I haven't often dealt with arrays with 200K rows {g}. Yes, as suggested, the best option would be to stick with APPEND FROM. Of course, if you're seriously concerned about the speed, and you've gone to the steps of deleting the indexes and recreating them, and you're familiar with C, then you could write a routine to fire the information into the .DBF file a whole lot faster than FoxPro does. But it will take a reasonable understanding of the structures of the two files, and some care to ensure that the rows added to the .DBF follow the structure. /Paul