BULK INSERT  table
FROM 'c:\file.csv'
WITH
( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
GO