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

Cheers,
Jason

On 1 May 2006 09:34:19 -0700, rob wrote:

This will be an ongoing thing. I was thinking about opening it in Excel
(programatically) and store it with tabs but there is a chance some of
the cell content contains tabs as well. Another option would be to open
the file in Excel (programatically) and then read out the cells. This
is a huge overkill, though. Worse it's something that will run on a
server. Although it usually runs during off-peak times I still don't
like the idea doing it this way. Therefore, I might really end up
writing my own parser. Thanks for the input, though. It's definitely
appreciated.

Jason,

Thanks a lot for this link. It sounds promising and I'll give it a try.
I hope that'll safe my day...:)

I did try the CsvReader and it fails with the exact same item as in the
odbc approach. One additional thing I realized is that many items/cells
do have words in double quotes. As far as I know double quotes should
be put in double double quotes. The data I have sometimes does that but
often it does not. Both approaches (odbc, cvsReader) work fine (can
read though don't render correctly) if the cell in question is the last
one. If it is not the last one both odbc and cvsReader get thrown off,
though.

So the conclusion here is that from all I know only Excel can handle
things in a way that works out but that parser is not directly
accessible in the .NET framework. Therefore, I will have to write my
own parser or maybe modify cvsReader.