Hi,
I think the fastest method for a lot of data would be to export the data from VFP to an ASII file and import it into the SQL Server table using the bcc import utility. The downside with this method is, that you don't have a lot of control on the single insertions or error states.
HTH,
Armin
>Hi everyone,
>
>I'd like to know your thoughts on which is the best approach for inserting data in SQL Server tables.
>
>Using SQLEXEC(...) and passing a long INSERT sql statement.
>or
>Using a remote view:
>USE RemoteView NODATA
>APPE BLANK
>.
>.
>.
>TABLEUPDATE()
>
>This is strictly from a VFP and performance points of view.
>
>Cheers!