CSV importing support

[liptonIcedTea]

Hi,

I was wondering if the vb.net API has any support for CSV?

I can't seem to find anything on it.

 

[jmcilhinney]

The Jet OLEDB provider supports CSV files. You import them essentially as though the folder was a database and the file a table.

http://www.connectionstrings.com/?carrier=textfile

 

[JohnH]

There is the TextFieldParser class.

 

[rfaricy]

Either of those works or you can always read each line, do a String.Split(",") and create your own DataSet if you want full control over the parsing routine.

 

[JohnH]

Problem with String.Split is if the fields are quoted, which text fields usually are in order to allow delimiter chars in the text. If not this method is sufficient.

 

[cjard]

if you want full control over the parsing routine.

a.k.a a lot of work reinventing a wheel that Microsoft already invented!

 

[liptonIcedTea]

hi guys,

i ended up using this free library

http://www.codeproject.com/cs/database/CsvReader.asp

and it worked good, so i'm happy becausei don't even have to know anything about CSV!