>Hi Cetin,
>
>>.Net doesn't need to read it line by line using a filestream. It could use a CSV provider
>
>I'm quite sure you have way more .NET knowledge than me. I'd really like to see if a CSV provider is really faster than using a file stream. Could you show me some sample code?
>
>TIA,
>
>Markus

As I promised here is a sample:

using System;
using System.Data;
using System.Data.OleDb;
using System.IO;

class test
{
 static void Main()
 {
   OleDbConnection con = new OleDbConnection();
   con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"+
     "Data Source=c:\\temp\\;Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";
   OleDbCommand cmd = new OleDbCommand("select * from myCSV.csv",con);
   con.Open();
   OleDbDataReader rdr = cmd.ExecuteReader();

   int row=1;
   while (rdr.Read())
   {
     Console.WriteLine("Row #{0}",row++);
     for(int i=0;i<rdr.FieldCount;i++)
     {
       Console.WriteLine("\t{0}\t:{1}",rdr.GetName(i), rdr[i]);
     }
   }
   rdr.Close();
   con.Close();
 } 
}

Cetin