It is very very simple any body can do it..... follow below post .... and enjoy with sql server
CSV stands for Comma Separated Values, sometimes also called Comma Delimited Values.
CREATE TABLE CSVTest
Create CSV file in drive C: with name csvtest.txt with following content. The location of the file is C:\csvtest.txt
Now run following script to load all the data from CSV to database table. If there is any error in any row it will be not inserted but other rows will be inserted.
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
--Check the content of the table.
--Drop the table to clean up database.