Re: Fastest way to update Data from text File

2005-02-15 10:39:14 PM
If you want speed then forget the ADODataSet and using Locate. If you must
do some processing of the data on the client side then use two TADOCommand
objects, one with a parameterized INSERT and the other with a
parameterized UPDATE. The logic is:
If you have more updates than inserts then reverse the commands and try
the UPDATE first.
If you do not have to do processing on the client side then import the
data into a temporary table using BCP or DTS (see BOL for details). Then
write a stored procedure that uses the logic above to insert the data.
Bill Todd (TeamB)
TeamB cannot answer questions received via email