Microsoft oledb data acces truncates the data length to 255 characters RRS feed

  • Question

  • 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

    Tuesday, June 11, 2013 5:30 AM