Bulk insert/upload microsoft sql server (csv)


/ Published in: SQL
Save to your folder(s)

Bulk upload a CSV into Microsoft SQL Server


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.