I am displaying the contents of a CSV file into a DataGridView using an OleDbAdapter. The problem is once the data is in the DataGridView, some of the cells in the first row(which is the column headers in the CSV file) are blank. I have noticed the cells that are blank, are the header text for a column that contain numbers. I have tried placing quotes around the numbers in the CSV file and around the column headers but that has not helped. I am using cs.net 2008. In the code, fileName is a variable that is set before the TryCatch. All the data with the exception of row one is displaying correctly. Any help will be greatly appreciated.
OleDbConnection myConn = new OleDbConnection(connString);
DataTable dTable = new DataTable();
OleDbDataAdapter myDa = new OleDbDataAdapter("SELECT * FROM[" + fileName + "]", myConn);
this.dataGridView_MonitorResults.DataSource = dTable;
catch (Exception ex)