BULK INSERT
FROM ‘C:\Users\AdmSitt\Desktop\Cartel2.csv’
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ‘;’, –CSV field delimiter
ROWTERMINATOR = ‘\n’, –Use to shift the control to next row
–ERRORFILE = ‘C:\Users\AdmSitt\Desktop\Cartel2ErrorRows.csv’,
TABLOCK
)
Category:
SQL