>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
Jon Rosenbaum
Devcon Drummer