×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Sacramento

FYI

gugu(GuGu)
本文发表在 rolia.net 枫下论坛CAUSE
The Jet OLE DB provider reads a registry key to determine how many rows are to be read to guess the type of the source column. The registry setting is:

HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows

By default, the value for this key is 8. Hence, the provider scans the first 8 rows of the source data to determine the data types for the columns. If any field looks like text and the length of data is more than 255 characters, the column is typed as a memo field. So, if there is no data with a length greater than 255 characters in the first 8 rows of the source, Jet cannot accurately determine the nature of the data type.
WORKAROUND
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To change the value of TypeGuessRows, use these steps:
On the Start menu, click Run. In the Run dialog box, type Regedt32, and then click OK.
Open the following key in the Registry editor:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Double-click TypeGuessRows.
In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 and 16, inclusive, for Value data.
Click OK, and then exit the Registry Editor.
A second way to workaround this problem (without modifying the registry) is to make sure that rows with fields, which have data 255 characters or greater, are present in the first 8 rows of the source data file.更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#1247766@0)
Last Updated: 2003-6-18
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 用SQL IMPORT WIZARD将EXCEL文件导入到SQL中，由于某些CELL的内容很长，超过200个字符，结果说超过bufferized size,不成功，应该怎么解决？thanks a lot -haihai(好了，大概是250); 2003-6-18 (#1247729@0)
    • FYI -gugu(GuGu); 2003-6-18 {1624} (#1247766@0)
      本文发表在 rolia.net 枫下论坛CAUSE
      The Jet OLE DB provider reads a registry key to determine how many rows are to be read to guess the type of the source column. The registry setting is:

      HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows

      By default, the value for this key is 8. Hence, the provider scans the first 8 rows of the source data to determine the data types for the columns. If any field looks like text and the length of data is more than 255 characters, the column is typed as a memo field. So, if there is no data with a length greater than 255 characters in the first 8 rows of the source, Jet cannot accurately determine the nature of the data type.
      WORKAROUND
      WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

      To change the value of TypeGuessRows, use these steps:
      On the Start menu, click Run. In the Run dialog box, type Regedt32, and then click OK.
      Open the following key in the Registry editor:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
      Double-click TypeGuessRows.
      In the DWORD editor dialog box, click Decimal under Base. Type a value between 0 and 16, inclusive, for Value data.
      Click OK, and then exit the Registry Editor.
      A second way to workaround this problem (without modifying the registry) is to make sure that rows with fields, which have data 255 characters or greater, are present in the first 8 rows of the source data file.更多精彩文章及讨论，请光临枫下论坛 rolia.net
      • thanks a lot, It really works. btw, where did you find it? -haihai(好了，大概是250); 2003-6-19 (#1248640@0)
        • find solution from Microsoft website for MS Error. -gugu(GuGu); 2003-6-19 (#1248738@0)
    • 当你作到"select source tables and views" 那一步的时候，在"Transform"下面有个button(上面有3个点),点这button进去"Column Mappings"， 从哪里可以修改column size -zxcvb(朝天椒); 2003-6-19 (#1248294@0)
      • 兄弟，这个方法我试验过了，我改成NTEXT类型，但还是不工作，好象没有作用的。楼上的写的解决问题了。THX。 -haihai(好了，大概是250); 2003-6-19 (#1248643@0)
        • 呵呵，sorry,你不是XD，是猫姥姥，：D -haihai(好了，大概是250); 2003-6-19 (#1248709@0)
          • 这可如何是好 -zxcvb(朝天椒); 2003-6-19 (#1248730@0)

More Topics

  • 哪位Excel大神帮忙解答一下，一个spreadsheet一表格connection到另外一个spreadsheet，原来的data是数字格式，但是connection以后变成text格式，这是为什么呢？这两天才出现的问题，之前好多年没有过这样的问题。谢谢先
  • 中国政府官方的行为，证明了，苹果手机是世界上最安全的手机。感谢乔布斯先生。感谢库克先生硬是顶住了美国政府的最强大的压力。
  • 老程序员第一次用copilot的一点点体会
  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论