Sergio,
Look at this link:
http://www.connectionstrings.com/?carrier=textfileI think what you are looking for is the OLE DB Delimited Columns area. I have never used this myself, so I cannot help much more. I am assuming you will need an System.Data.OleDb.OleDBConnection with this connection string to read into a dataset.
>Hello UT,
>
>I need to load a text file(comma delimited ), then manipulate the the four fields in it and insert the fields into a foxpro table(using c#).
>
>
>The text file looks like this :
>(policy #, amount, check#, check type)
>
>00000000592245122,00000000400,0000000000,1
>00000000592245122,00000000100,0000000000,1
>00000000892046820,00000027340,0000000484,1
>00000000892046820,00000150000,0000000484,1
>
>
>I think I can use IO.StreamReader class to open the file and read it but not sure if I can load it directly into a Dataset.
>If anybody have an example or advise on what is the best way to do it I would appreciate it.
>
>Thanks