importing csv into sql server

Question

hi i need help on how to import a .csv file into sql server using asp.net (c#) thanks.

White Evaln · Answer

use a free data export component to give it a try. It supports csv .

Sukesh Marla · Answer

BULK INSERT CSVTestTable FROM 'c:\csvtest.txt' WITH ( FIELDTERMINATOR = ''  ROWTERMINATOR = '
' ) 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.