This is to import into a datatable or dataset:
string connectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + directoryName;
string SQL = "SELECT * FROM " + fileName;
// Create connection object
OdbcConnection conn = new OdbcConnection(connectionString);
// Open connection
conn.Open();
OdbcDataAdapter da = new OdbcDataAdapter(SQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = new DataTable();
dt = ds.Tables[0];