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;