hi,
i need help on how to import a .csv file into sql server using asp.net (c#)
thanks.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
White EvalnPosted Sep 10, 2012, 12:03 AM
Sukesh MarlaPosted Sep 9, 2012, 1:42 PM
INSERT CSVTestTable
FROM 'c:\csvtest.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
fire this query
if still have some query
Watch this video
http://www.youtube.com/watch?v=ZeCKVwFKXQo&feature=player_embedded
come again if problem not solved.
Check this is correct answer if it helped.