read data from a csv file and insert it in a sql server databse table

Hai Everbody,

for me in my project i want to read data from a csv file and insert it in a sql server databse table.The csv file may contain n number of columns,but i want only certain columns from that, and insert it in the database table.How to achieve this. Plz help me it is urgent. Thanks in advance.

Thanks and regards

Biju.S.G

http://www.dotnetspider.com/kb/Article1082.aspx

http://www.devarticles.com/c/a/ASP.NET/Reading-a-Delimited-File-Using-ASP.Net-and-VB.Net/