Unable to insert a large string into an excel cell using OLEDB


Hi All,

We are using OLEDB for excel operations and we have a scenario where we have to insert large text i.e., greater than 255 characters into an excel cell using OLEDB. While performing insert query OLEDB throws an exception.

Has anyone faced this issue before, and what is the workaround for this? Thanks in Advance.