>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

I doubt that this is the best or fastest way of doing it, but I have a utility which builds the command for an SQLEXEC statement. It does this for one record at a time, but it should be a simple task to modify it to scan an entire table or put some kind of scoping clause into it.

You're probably better off finding a method using remote views, but let me know if this appeals to you and I'll post the code.