> 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