Import Excel

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  October 31, 2005 at 7:04 am

  #169569

  Hi

  I am trying to import an excel file into my DB but i am getting the follwing error..

  ---

  Data for source column 15('column')is too large for the specified buffer size.

  ---

  The error column has text and integers in it,its an nvarchar datatype.

  Can any one tell me what is this, wht i need to do to import my excel file.

• Don Staten

  SSC Eights!

  Points: 957

  More actions

  October 31, 2005 at 7:21 am

  #601286

  Please see Microsoft article 281517 (http://support.microsoft.com/default.aspx?scid=kb;en-us;281517) for more information about this issue.

  Other references:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=160515

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=107172

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  November 2, 2005 at 7:34 am

  #601832

  I've got exactly the same problem but the only reliable solution I've found is to move the rows containing the largest columns into the first 8 row.

  This is a known issue with the driver and all workarounds (like changing the registry etc.) is useless.

  
  
  Bye
  Gabor