truncate at 255 characters with xlsx files（OLEDB方式读取Excel丢失数据、字符串截断的原因和解决方法）

The TypeGuessRows setting is supported by ACE. Note the version numbers in the key may change depending upon the version of Office installed.

For 32-bit Windows (32-bit Office):
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice12.0Access Connectivity EngineEnginesExcel

For 64-bit Windows (32-bit Office):
HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice12.0Access Connectivity EngineEnginesExcel

 Change TypeGuessRows  to 0.

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/wmlunge/p/11265661.html