03 January 2011

Bulk insert From CSV file using Sql

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