Help reading alphanumeric field in excel
## Deliverables
I have a application that I need to be running by wednesday and I'm having problem reading the excel.
I'm "Provide=Microsoft.Jet.OLEDB.4.0;Data Dource=" + strPath + @"Extended Properties=""Excel 8.);HDR=Yes;IMEX=1""";
I use IMEX=1 to inform the connection to accept alphanumeric column but is not working properly. I'm able to fill a grid and it works well but when looping to update the table usin Dataset, OleDBReader, or a DataTable the alphanumeric rows retune a null.
You dont even need to update the table just help solve this problem by debuging the function.
I'll provide the function and Excel sheet