Excel无法插入超过255个字符？ [英] Excel unable to insert more than 255 chars?

问题描述

我正在使用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:

异常详细信息：System.Data.OleDb.OleDbException：该字段太小，无法接受您尝试添加的数据量。尝试插入或粘贴较少的数据。

Exception Details: System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

似乎来自这个线程它是一个Excel限制。即使是微软网站似乎也是这样说的这里。

Seems from this thread that it's an Excel limitation. Even the Microsoft site seems to say so here.

这是否意味着我无法通过编程方式，但我可以手动？因为当我在Excel中手动输入时，可以输入超过255个字符。那么它是一个 Microsoft.ACE.OLEDB.12.0（AccessDatabaseEngine.exe）驱动程序限制？

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个字符问题，其中包含以下解决方法： http://support.microsoft.com/kb/213841

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个字符？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！