I need to insert 400,000 records from a VFP8 table into a Sql Server table nightly.

I have created an updatable remote view in my VFP DBC to this SQL Server table. I then update the Sql Server table as follows.

***
USE myRemoteView IN 0
USE myvfptable IN 0
SELECT myvfptable
SCAN
   SCATTER MEMVAR
   INSERT INTO myRemoteView FROM MEMVAR
ENDSCAN
***

All this works, but it takes a long time to complete. Is there a faster way to run this process? How can I speed this up>

Thanks,

Jerry