Insert Bulk Records From Text File

This SQL command bulk inserts records from a flat file like .txt and .csv into  the SQL Table

BULK INSERT Table1
FROM 'C:\TextFile.txt'
WITH(FIELDTERMINATOR =',' , ROWTERMINATOR = '\n')