The code below reads an MS Access database & fills a data adapter. The daMdb.Fill(dsMdb) fails, however, when it encounters the MI column -- chich is all numms at this time. I have several columns which allow nulls; how to read into a dataset without failing?
string MDBconnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbFile + ";";
OleDbConnection cnnAccesss = new OleDbConnection(MDBconnectionString);
string SQLselect = "SELECT Client.FirstName as first_name, " +
"Client.LastName as last_name, " +
"Client.MI as mi_initial " +
OleDbDataAdapter daMdb = new OleDbDataAdapter(SQLselect, cnnAccesss);
DataSet dsMdb = new DataSet();