Connect to a CSV file using ODBC [C#]

I mentioned that it’s easy to work with CSV/XML files using ODBC, ADO.NET, etc. Here is some sample C# code that works with CSV files using ODBC (using System.Data.Odbc):

string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};" +
  "Dbq=C:;Extensions=csv,txt";

try
{
  OdbcConnection objCSV = new OdbcConnection(strConn);
  objCSV.Open();

  OdbcCommand oCmd = new OdbcCommand("select column1,column2 " +
    "from THECSVFILE.CSV", objCSV);
  OdbcDataReader oDR = oCmd.ExecuteReader();

  while (oDR.read())
  {
    // Do something
  }
  oDR.Close();
  oCmd.Dispose();
  objCSV.Close();
}
catch {}

In the Connection String, DBQ only points to the directory which contains the CSV files you want to work with. Use the name of the CSV file in the SQL Statement itself, as in the code above.

Simple?