How can I inserting mulitple rows in SQL2000 dbase

I was working on web app on asp.net which uses sql dbase 2000. I have lots of data that I want fill into the dbase. Is there any way to do it other than insert one at a time. I am newbie to the Sql and asp.net so please if I could get some kind of example that would help. My data is text data, like NAMES, Descriptions etc..<br>thanks<br> <img border="0" src="/forum/emoticons/confused.gif" height="22" width="15" alt="confused" />

Personally, I dont have good simple way to meet your request myself. <br>This is I can tell you. <br>firstly, your text file need to match to your tables (columns and rows). Each of fields need to seperate with either ";: or :,:.<br>Seccodly, you need to loop your text file then insert into your table. <br><br>Here is some other tips I can give to you.<br>1. load data from SQL2000 by uisng import data or DTS package.<br>2. Make your text file as XML file which match to your table. Then u can load the XML to ur DataSet. Then commit ur dataset to ur database. <br><br>PS. if u just want to load the file then use SQL2000, its faster and the simpest. If u must load file from ASP.NET then use XML.<br><br>Hope this can help u.