John,
My test is running slow from record one - I have 1000 records in my test file and give up after five minutes (300 records). The target tables are empty at the moment and the clustered index is on the identity column. I might try a longer test later to see if the speed gets worse after more records.
>Hi Nigel ---
>
>Two suggestions before running:
>
>1) Drop any INSERT triggers you may have defined for the SQL table.
>2) Drop any clustered index you may have defined.
>
>I, too, have VFP blow up in my face when doing mass inserts to remote tables. I've had to work in 200-1000 record chunks because of this.
>
>