Import Data from a Text or CSV file into SQL Server

http://www.codeproject.com/Articles/290242/Import-Data-from-a-Text-or-CSV-file-into-SQL-Serve


bulk insert [dbo].[Cust_Data_500] from 'C:\Unica_Work\Misc\CustData.csv' with (fieldterminator = ',',rowterminator = '\n')