shyam kumar

shyam kumar

  • NA
  • 17
  • 0

Help-Inserting CSV data into sql server

Feb 25 2009 8:35 AM

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

Answers (5)