For training related to .net,OOPS,design patterns, MVC,WCF and .net fundamentals
contact at sukeshmarla@gmail.com or Click Here

03 January 2011

Bulk insert From CSV file using Sql

BULK
INSERT 
CSVTest
FROM 'c:\csvtest.txt'
WITH
(
      FIELDTERMINATOR ',',
      ROWTERMINATOR '\n'
)