reading CSV as String using ASP.Net(C#)

Asked Dec 18 '11 at 11:46

Active Dec 18 '11 at 11:51

Viewed 739 times

i want to read CSV files as string and then save as xml in sqlserver table.

i want to do some thing like this with csv

FileStream stream = File.Open(FilePath, FileMode.Open, FileAccess.Read);

IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
 DataSet result = excelReader.AsDataSet();

how it could be possible?

edited Dec 18 '11 at 11:51

Oded

489,969
99
883
1,009

asked Dec 18 '11 at 11:46

Methew

http://stackoverflow.com/questions/1898/csv-file-imports-in-net – TOUDIdel Dec 18 '11 at 12:00
i do not want to use OleDb etc.i do not want to use filehelper.i have alot of data having ','.i can not use kent?any odumentation for kent how to use? – Methew Dec 18 '11 at 12:11
Why do you want to use Excel for this? Why not just instrument the SQL Servers import/export module? – Dec 19 '11 at 00:33

reading CSV as String using ASP.Net(C#)

0 Answers0