Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.dotnet.general
rob
 
Posts: n/a
Default Parse csv files

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing read-write Excel 2003 files ttt8262 Excel Discussion (Misc queries) 0 April 1st 06 09:39 PM
Recently Used File List - 2002 Contains 'Temp' Files Keith972002 Excel Discussion (Misc queries) 0 July 26th 05 01:46 PM
merging my excel files Donna YaWanna Excel Discussion (Misc queries) 1 June 14th 05 12:53 AM
Cannot access read-only documents. tomgillane Excel Discussion (Misc queries) 14 February 7th 05 10:53 PM
Automatic Data Import TxRaistlin Excel Discussion (Misc queries) 2 February 4th 05 10:43 PM


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"