...too large for the specified buffer size

• ryanm

  Say Hey Kid

  Points: 690

  More actions

  April 17, 2003 at 8:35 am

  #151821

  I have an Excel Spreadsheet, which I want to import into SQL Server 2000. One of the columns (Passenger Names) contains over 300 characters.

  When I do the import, I get the following error:

  "Data for source column 62 ('Passenger Names') is too large for the specified buffer size."

  I'm guessing that it is because this column is so long.

  I thought this might help, but does not:

  In the 'Select Source Tables and Views' screen of the DTS Wizard, I select the table, then click the button in the Transform column, select the column 'Passenger Names' and change the datatype nvarchar size to 350.

  But, as I said that does not work.

  any help or suggestions?

  Thanks,

  Ryan.

• ganeshmuthuvelu

  SSCrazy

  Points: 2177

  More actions

  April 18, 2003 at 11:17 am

  #454682

  You have to change your registry settings to correct this problem.

  Take a look at this article in MS KB : article #Q281517

• ryanm

  Say Hey Kid

  Points: 690

  More actions

  April 22, 2003 at 2:18 am

  #454865

  Thanks for your help, but please excuse me if this sounds stupid,

  What is MS KB?

  Thanks,

  Ryan

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  April 22, 2003 at 2:37 am

  #454866

  Microsoft Knowledge Base

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]