Monday, 25 October 2010

BULK INSERT csv data into a SQL Server table 

BULK
INSERT tblDespatchBySize
FROM 'D:\path\myFile.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
Topics:

No comments:

Post a Comment

Comments are moderated, so you'll have to wait a little bit before they appear!

Subscribe to: Post Comments (Atom)