The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

Question

User341011106 posted

I am using  OLEDB.12.0 to update EXCEL xlsx file. I am getting the error if the data exceeds 255 Characters.

I have a very huge aount of data to keep in the fields, how to accomplish this through c# windows application.

is there any registry setting changes helps. please suggest.

Thanks in advacnce.

Answer 1

User535082756 posted

hi just a thought..hope it helps

Change the Preparation SQL task query, change the data type as varchar(Max) and modify the excel source ->advanced editor and change the output columns type and length and external column type and length.

or else you can also right to next cell whenever the length exceeds 255. I mean logic can be like this

cell one -- write the text from 0 to 255 and then write the cell two -- write the text from 256 to 510

hope it helps...thanks....

 

Answer 2

User-1199946673 posted

is there any registry setting changes helps. please suggest.

 

 

http://support.microsoft.com/kb/281517

how to accomplish this through c# windows application

Note that these forums are intended for ASP.NET related questions only. Next time, for Windows appliction, use http://windowsclient.net/Forums/