Right, it will be more quick.
Another approach for data transfer is copying data into the TXT file and appending it to SQL Serevr table using BCP utility or BULK INSERT from server, but this require a lot of programming. However, this is useful only for table with large number of fields and records.
>I tried it with a loop for 1,000 iterations, and for some reason it only inserted 455 records. (I didn't get an error, but I'm guessing there was truncation somewhere along the line).
>
>However, I can still use this, maybe build a string of 150 or so at a time, which is still much much better.
>
>Thanks for your help! I'm still a newbie at some of this, but I've really learned a good amount from your replies.
>
>Kevin
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
