Advanced Search

Bulk insert/upload microsoft sql server (csv)

/ Published in: SQL
Save to your folder(s)
Bulk upload a CSV into Microsoft SQL Server

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. BULK INSERT [TABLE name]
  2. FROM 'file path and name (either .txt or .csv)'
  3. WITH
  4. (
  5. 	FIRSTROW = 2,
  6. 	FIELDTERMINATOR = ',',
  7. 	ROWTERMINATOR = '\n',
  8. 	KEEPNULLS
  9. )
  10. GO

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.