×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Calgary

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

  • Torvalds patch improves Linux performance by 2.6%
  • GitHub Spark
  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论