When getting data from excelsheet to C# dataset :
I am using
connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;IMEX=1;HDR=NO;\"";
and
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;IMEX=1;HDR=NO;\"";
I have to make general formatting for column(s), so that able to update Database as integer column.
Ex
12,220 --> 12220
15,445 --> 15445
55,881 --> 55881
Number(-1,234) --> Number(General)
I don't want fix(s) by row (by) row operation
it will degrade performance