Is there a way to connect through an OleDBConnection to a
comma-delimited file? Then I could read records through a DataReader.
I was thinking it could be done through the ExtendedProperties, but I
cannot find the right value for it (I would probably need to specify
field and row delimiters).


Thanks.

You could try this:

http://www.developerfusion.co.uk/show/961/

It uses the MS Jet

Unless you have a special reason for using OleDbConnection, create a
data source in ODBC using the Microsoft Text Driver. Then use
OdbcConnection instead of OleDbConnection.

FireStarter wrote:
> Is there a way to connect through an OleDBConnection to a
> comma-delimited file? Then I could read records through a DataReader.
> I was thinking it could be done through the ExtendedProperties, but I
> cannot find the right value for it (I would probably need to specify
> field and row delimiters).
>
>
> Thanks.

Thank you, after a couple of changes to bring it to C# syntax, this
worked perfectly.


Jerry H. wrote:
> You could try this:
>
> http://www.developerfusion.co.uk/show/961/
>
> It uses the MS Jet
>

Thank you for the idea. I went with OleDB because I wanted the solution
to be portable on other comps w/o having to add ODBC sources. It would
have worked, though.


(E-Mail Removed) wrote:
> Unless you have a special reason for using OleDbConnection, create a
> data source in ODBC using the Microsoft Text Driver. Then use
> OdbcConnection instead of OleDbConnection.
>
> FireStarter wrote:
>
>>Is there a way to connect through an OleDBConnection to a
>>comma-delimited file? Then I could read records through a DataReader.
>>I was thinking it could be done through the ExtendedProperties, but I
>>cannot find the right value for it (I would probably need to specify
>>field and row delimiters).
>>
>>
>>Thanks.
>
>