Import MSSQL CSV file

Date: 2023-01-17
DELETE FROM [dbo].[afwezigheid];

SET IDENTITY_INSERT [dbo].[afwezigheid] ON;

BULK INSERT [dbo].[afwezigheid] FROM 'C:\afwezigheid.csv'
   WITH (
      FIELDTERMINATOR = ';',
      ROWTERMINATOR = '\n',
	  KEEPIDENTITY,
	  KEEPNULLS,
	  BATCHSIZE = 5000,
	  MAXERRORS = 10000
);

SET IDENTITY_INSERT [dbo].[afwezigheid] OFF;
72190cookie-checkImport MSSQL CSV file