The the VFP OLEDB provider has to be installed on the SQL Server PC.
Did you consider using DTS?

>I am trying to insert data from a large VFP table into a MS Sql Server Table.
>
>Below is my code. My problem is that I keep getting an error that 'SQL Server could not locate the registry entry for OLEDB Provider VFPOLEDB.1'.
>
>What would that mean? I do have MDAC 2.8 installed and I can use the VFP OLEDB provider elsewhere in my applications.
>
>

>***Current code
>conn  = SQLSTRINGCONNECT(MyConnectionString)
>
>Text to lc_sql textmerge noshow
>INSERT INTO mysqltable
>    SELECT field1, pr_field2, field3
>     FROM OPENROWSET('VFPOLEDB.1',
>     'c:\mypath\myvfp8.dbc';;,
>     'SELECT field1, field2, field3 FROM myvfptable')
>ENDTEXT
>=SQLEXEC(conn, lc_sql)
>

>
>Also, is there a better way to quickly insert a large amount of VFP data into a SQL Server table?
>
>I tried using a remote view and buffering set to 5, while this works, it is very slow. I even tried performing the tableupdate() after every 500 records, but this still took a long time. I am trying to insert over 400,000 records.