Reading excel with Microsoft.ACE.OLEDB.12.0 is truncating values to 255 characters RRS feed

  • Question

  • Hi

    I am using ACE oledb(Microsoft.ACE.OLEDB.12.0) for reading Excel in C#. but when i am writing to datatable its able read only 255 characters. this is some thing related to setting datatype automatically .. i tried changing 'typeguessrows' in the registry but still it did nt work.. what possible solutions for this problem..?

    Thanks in advance

    Saturday, October 20, 2012 8:12 AM