1 | initial version |
To parse CSV files using OleDb in C#, you can follow these steps:
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=filepath;Extended Properties=\"Text;HDR=YES;FMT=Delimited\"";
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
string query = "SELECT * FROM [filename.csv]";
OleDbCommand cmd = new OleDbCommand(query, conn);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
Console.WriteLine(row[0].ToString() + " " + row[1].ToString() + " " + row[2].ToString());
}
conn.Close();