Help-Inserting CSV data into sql server

Question

guyz,

           i have table called CSVTest which has  ID int, First name char(50) fields. Then i have a text file called csv.txt  in my  C:\ drive. The csv.txt contains

1,sk
2,test
3,test2

i tried to do a bulk insert but it failed and the error message is unable tofind the file.

Now guyz i want to insert the csv data into my sql server using either sql query or VB.Net code

please help me

thank in advance

sk