问题描述
我正在使用OLE DB驱动程序在Excel工作表中插入超过255个字符，但是我收到错误：
I am using OLE DB driver to insert more than 255 characters into an Excel sheet, but I get the error:
似乎来自它是一个Excel限制。即使是微软网站似乎也是这样说的。
Seems from this thread that it's an Excel limitation. Even the Microsoft site seems to say so here.
这是否意味着我无法通过编程方式，但我可以手动？因为当我在Excel中手动输入时，可以输入超过255个字符。那么它是一个限制？
So does this mean I can't programmatically, but I can manually? Because I can enter more than 255 characters when I manually type them in Excel. So is it a Microsoft.ACE.OLEDB.12.0(AccessDatabaseEngine.exe) driver limitation?
推荐答案
您要引用的链接是大约256列而不是字符。此处介绍了256个字符问题，其中包含以下解决方法：
The link you are refering to, is about 256 columns and not characters. The 256 characters problem is described here with a workaround: http://support.microsoft.com/kb/213841
这篇关于Excel无法插入超过255个字符？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！