Have you tried using a linked server in SQL Server or SSIS?
I've only dabbled in them and I'm not sure about the speed, but they give you a way to update VFP tables from SQL Server tables without running any VFP code.
>>Is there a way to speed this up? Years ago I used BCP, don't remember much about it right now, but thinking it would speed up writing to a text file, but then I'd have to append into a dbf anyway.
Is there any way to bypass sending results to a cursor first, a way to use sqlexec to go straight to a dbf?
Any way to speed up the copy to?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.