Import CSV file into SQL Server

Create a table schema and specify the name in Bulk Insert command

BULK
INSERT Table_Name
FROM 'C:\temp\sample_file.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO