Import CSV into MSSQL database

Use the MSSQL command following, to import the CSV file into the Microsoft SQL (MSSQL) table

MSSQL command:

BULK
INSERT [dbo].[TABLE_NAME]FROM 'c:\files.csv'WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')GO