Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

sai_bhargavaraj
Level 3

‎28-09-23 07:27 AM

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.

0 Likes
2 REPLIES 2

SteveBoggs
Staff
Staff

‎28-09-23 03:38 PM

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?

0 Likes

harish.m
Level 12

‎28-09-23 04:21 PM

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

----------------------- If I answered your query. Please mark it as the "Best Answer" [FirstName] [LastName] [Designation] [JobTitle] [City] [State] [Phone]
0 Likes