03 January 2011

Bulk insert From CSV file using Sql

BULK
INSERT CSVTest
FROM 'c:\csvtest.txt'
WITH
(
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '\n'
)
By at
Labels: ,

No comments:

Post a Comment

Your comments, Feedbacks and Suggestions are very much valuable to me :)

Subscribe to: Post Comments (Atom)

Things are upgraded

My Dear readers, I am really thankful for being supportive all these years. This site was the first blog site I ever created in my life...