/ Published in: SQL

Bulk upload a CSV into Microsoft SQL Server
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
BULK INSERT [TABLE name] FROM 'file path and name (either .txt or .csv)' WITH ( FIRSTROW = 2, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n', KEEPNULLS ) GO
Comments
