oledb从excel中仅读取255个字符 [英] oledb is reading only 255 characters from excel

问题描述

嗨..

我正在使用ACE oledb阅读excel.但它的阅读仅有255个字符.如何解决此问题..

在此先谢谢您.

Hi..

I am reading excel using ACE oledb. but its reading only 255 charaters . How to fix this issue..

Thanks in advance.

推荐答案

请看看:
http://stackoverflow.com/Questions/9889998/data-truncating-after-255-characters-when-insertting-into-dataset-from-excel-but [ http://social.msdn.microsoft.com/Forums/lt-LT/exceldev/thread/6ec8cb05-effe-4991-bf4c-43dd9b583081 [ http://social.msdn.microsoft.com /Forums/zh-CN/adodotnetdataproviders/thread/cf21f1be-d6e8-4ed9-b977-d6876bf0cf06/ [

Please have a look:
http://stackoverflow.com/questions/9889998/data-truncating-after-255-characters-when-inserting-into-dataset-from-excel-but[^]
http://social.msdn.microsoft.com/Forums/lt-LT/exceldev/thread/6ec8cb05-effe-4991-bf4c-43dd9b583081[^]
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/cf21f1be-d6e8-4ed9-b977-d6876bf0cf06/[^]

It seems that using "range" instead of "sheet" in the select commands can get over the restriction

这篇关于oledb从excel中仅读取255个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！