Thursday, January 19, 2012

Insert Data from TextFile to table


BULK INSERT dbo.User_MST
FROM 'c:\TestCSV.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR='\n'
)
SELECT * FROM dbo.User_MST

No comments:

Post a Comment