Sergey,
Thanks, I bet that the VFP OLEDB provider isn't on the Sql Server PC. I'll check into that.
I do not and will not have access to the Sql Server PC other than being able to query it. Will DTS work for be? Can you give me an example?
Thanks,
Jerry
>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.