Cacher is the code snippet organizer for pro developers

BULK
INSERT ITEMS
FROM 'C:\Users\sarpay\Desktop\pickmeter_report\files\items.csv'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

-- CSV FILE FORMAT : --
--ID,FirstName,LastName,TCKN
--,James,Smith,19750101
--,Meggie,Smith,19790122
--,Robert,Smith,20071101
--,Alex,Smith,20040202

--ID is the auto-incremented identity (PK) column