topic Re: Unable to insert a large string into an excel cell using OLEDB in Product Forum

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

sai_bhargavaraj — Thu, 28 Sep 2023 06:27:04 GMT

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.

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

steven.boggs — Thu, 28 Sep 2023 14:38:43 GMT

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?

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

harish.mogulluri — Thu, 28 Sep 2023 15:21:11 GMT

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