ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   saving blob (https://www.excelbanter.com/excel-programming/322769-saving-blob.html)

ntt123

saving blob
 
Hi,
I wonder why
when I am trying to save Sheet as a blob in sql server database
data inside cell is truncated when it is more than 255 characters
thanks

DoubarSingh

saving blob
 

Text data exceeding 255 char will displayed in cell as ####### .....

Have you tried to format the cell to "general"? It may display more
than 255 characters in this format!


--
DoubarSingh
------------------------------------------------------------------------
DoubarSingh's Profile: http://www.excelforum.com/member.php...o&userid=27777
View this thread: http://www.excelforum.com/showthread...hreadid=343774



All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com