Import into SQL Server from CSV

This is how to import data from CSV into SQL Server

BULK INSERT  TableName
FROM 'c:\data.csv'
WITH
(
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n'
)
GO
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published.