Posted By

dego89 on 05/17/13


Tagged

sql insert import upload batch csv Microsoft bulk


Versions (?)

Bulk insert/upload microsoft sql server (csv)


 / Published in: SQL
 

Bulk upload a CSV into Microsoft SQL Server

  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  

You need to login to post a comment.