Export data from Excel to SQL Server

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  February 14, 2013 at 10:35 pm

  #270223

  hi,

  when i 'm trying to export data from excel source to Sql server it is truncating the few fields.

  OLE DB provider 'Microsoft.Jet.OLEDB.4.0' for linked server '(null)' returned truncated data for column '[Microsoft.Jet.OLEDB.4.0].Usermobile'. The actual data length is 1026 and truncated data length is 510.

  is there any workaround to over above truncation issue?

  🙂

• Ant-Green

  SSC Guru

  Points: 113504

  More actions

  February 15, 2013 at 1:17 am

  #1588218

  Use the import export data wizard and tell it to ignore truncation errors.

• UmaShankar Patel

  Ten Centuries

  Points: 1142

  More actions

  February 15, 2013 at 3:11 am

  #1588249

  See various ways to export data from excel to sql server

  http://support.microsoft.com/kb/321686

  Thanks.......
  -----------------------------------
  My Blog[/url] | Articles