Results 1 to 2 of 2

Thread: DTS issue

  1. #1
    Join Date
    Nov 2002

    Angry Unanswered: DTS issue

    I am using DTS (the version that shipped with MSSQL 7.0).
    I am trying to import at space-delimited text file into a database table.
    I have one column in my text file which tends to exced 255 characters.
    When this occurs, I run into the following error during the import:
    'data for source column 3(colname3) is too large for the specified buffer size.'
    Microsoft recommended changing the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\TypeGuessRows from 8 to 0.
    This did not work.
    Any suggestions for defeating this error would be greatly appreciated.


  2. #2
    Join Date
    Jul 2002
    Just a guess, but is the registry key relevant? It looks like something Excel-specific.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts