Ok so we have a vb app (version 5) running in background on a server, every so often it checks a temp directory to see if a csv file has been downloaded from a unix box.

If it detects the file, opens it up for input, and reads line by line. Now here is the question

A typical line would be something like:

"Name","Sales","Projected"

We are currently using InStr and Mid to extract the individual data fields.

Is there an easier way??????????

Will be modifying the app this weekend, (feature creep strikes), to add zip and archiving to it and would like to be able to hack some lines out of it.

Thanks in Advance.