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.

Thanks,

Jerry