User383937017 posted
Hi all
When i use microsoft oledb driver for excel import, it truncates the data to 255 characters.
string
connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=" + FilePath +
";"
+ "Extended
Properties='Excel 8.0;HDR=YES;MAXSCANROWS=0;IMEX=1'";
Please provide some solutions