>what is fastest way to take records from a VFP table to an SQL table (all field names and definitions are the same in both files)?
>
>I have used append from, but that is slow
>
>Is Insert into the right way?
>
>I do not think I can use SQLEXEC
What about Create an Updatable CursorAdapter or Remote View, set Buffering=5 insert all records in it & then issue TableUpdate(). I don't know if this will be faster.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.