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

Jerry,

I've no idea of the performance difference, but you could also try this from the SQL Server end via a scheduled DTS task, as opposed to doing it in VFP.

Laterness,
Jon