Code for working with CSV files (CREATE and SELECT):

void Main()
{
 System.Data.Common.DbProviderFactories.GetFactoryClasses().Dump();
 var f = System.Data.Common.DbProviderFactories.GetFactory("System.Data.Odbc");
 var csTemplate = "Driver={{Microsoft Text Driver (*.txt; *.csv)}};Dbq={0};Extensions=asc,csv,tab,txt;";
 var cs = string.Format(csTemplate, @"C:\Users\calix\AppData\Roaming\CSV\");
 var ds = new DataSet();
 var c = f.CreateCommand();
 c.Connection = f.CreateConnection();
 c.Connection.ConnectionString = cs;
 var adapter = f.CreateDataAdapter();
 c.CommandType = CommandType.Text;
 c.CommandText = "SELECT * FROM [csv2.txt]";
 adapter.SelectCommand = c;
 adapter.Fill(ds);
 ds.Dump(); 
 c.CommandText = "CREATE TABLE T1.TXT (F1 CHAR(10))";
 c.Connection.Open();
 c.ExecuteNonQuery();
 c.Connection.Close();
}