Use Bulk Insert from stored procedure or you can use DTS package but use Bulk Insert is more straight forward process
Snapple ----- Original Message ----- From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Monday, November 10, 2003 11:22 AM Subject: Upload help > I've got a tab delimited file of 20,000 rows that I need to get into a DB. I > also need to transform some of the data as it comes in. I remember doing this > many years ago, but the exact SQL methodology escapes me. > Does anyone have the initials or reference to what I need? Thanks > > -- > Michael Dinowitz > Finding technical solutions to the problems you didn't know you had yet > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| In the beginning ColdFusion shipped with Website. Both have only gotten better http://www.deerfield.com/products/website/ Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1723 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
