Import into SQL Server from CSV

This is how to import data from CSV into SQL Server

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