bulk insert

Use bulk insert to load large CSVs. This script is fairly straight forward. Just update YourSchema.Your Table and YourFileName.csv.

For specific usage check out:

BULK INSERT YourSchema.YourTable
FROM 'E:\YourFileName.csv'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '0x0a',
FIRSTROW = 2
);

Last updated