Return to Snippet

Revision: 63566
at May 17, 2013 04:03 by dego89


Initial Code
BULK INSERT [table name]
FROM 'file path and name (either .txt or .csv)'
WITH
(
	FIRSTROW = 2,
	FIELDTERMINATOR = ',',
	ROWTERMINATOR = '\n',
	KEEPNULLS
)
GO

Initial URL


Initial Description
Bulk upload a CSV into Microsoft SQL Server

Initial Title
Bulk insert/upload microsoft sql server (csv)

Initial Tags
sql, csv

Initial Language
SQL