It should be noted that whilst this would "normally" work, it will fail if
the data contacts a comma ... eg
"hello","this has a comma, see!!",100
You would need to parse the string looking for opening and closing quotation
marks and taking commas between them as part of the data and not a
delimiter.
Herfried and Cor's suggestion for using the text connection string would do
this for you...
Regards
Simon
"Pipo" <Pi**@nobody.com> wrote in message
news:eN**************@tk2msftngp13.phx.gbl...
Hi Stefke,
dim SR as New StreamReader("c:\My Documents\info.csv")
dim txtLine as String
dim Strings as String()
txtLine = SR.ReadLine()
Strings()=String.Split(",",txtLine)
"Stefke" <sf***@tiscali.be> wrote in message
news:Ow**************@TK2MSFTNGP14.phx.gbl... Hi,
I've exported our Exchange 5.5 server info into a CSV file. I know want
to create a VB.Net application which reads the CSV file and then process the
information in it.
Can anyone tell me what I should do to create the application. The file
is called info.csv.
And I want to process it row by row.
Kind Regards
Stefke