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

[sai_bhargavaraj]

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.

[steven.boggs]

A 255 character limit on a single cell's contents is an Excel limitation, so you may have to get creative on how to concatenate, use an ampersand operator to join texts placed in different cells, or implement other available workarounds published on the web for these sets of data.

What is the exception seen when inserting the query using OLEDB?

[harish.mogulluri]

As Steve mentioned there is an excel limitation for each cell

Here is the  thread for excel limitation.

https://support.microsoft.com/en-gb/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3