SQL BULK Insert is a common question when it comes to importing CSV file using SQL Server T-SQL Bulk Insert command. However if you need flexibility, more control and you can use SSIS (SQL Server Integration Services) than I suggest to read this article instead SSIS create a package otherwise let's conitnue our tutorial. For the purpose of this tutorial I will use SQL Server 2008 R2 but it might also work in 2005, 2008 and 2012 versions.
Below is screenshot of Employee table that I will use to insert using SQL bulk insert rows from CSV file.
SQL Bulk Insert CSV File
In this tutorial we will use very simple CSV file that will contain Employee information. See below screenshot of EmployeeBulkInsert.csv file. You can also download SQL Bulk Insert CSV File
The CSV file will be loaded from C:\ location so I will use C:\EmployeeBulkImport.csv to import the CSV file.
SQL Bulk Insert example
I will now show you how to use SQL Bulk Insert command to import this very simple CSV file.
BULK INSERT dbo.Employee
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
Below is screenshot with command and results
Hope that helps