Excel data import problem..

• Vicky-854895

  Mr or Mrs. 500

  Points: 597

  More actions

  December 29, 2009 at 1:11 am

  #143849

  Hi,

  I'm trying to import data from MS Excel 2003 to SQL Server 2005. I have a column in excel sheet named 'address'. The column in database for this excel column is named as 'address' whose datatype is nvarchar(500).

  While import, I'm getting the following error,

  "Text was truncated or one or more characters had no match in the target code page.".

  I found that, this problem occurs when the address length in excel is large (maximum 269 in my case). So I incremented the size of address column in the database table. But still I'm getting the same error..

  What should I do?

  -Vicky

• Bocharov Iliya Vladimirovich

  SSC-Addicted

  Points: 451

  More actions

  December 29, 2009 at 2:13 am

  #1096940

  select *

  FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

  'Data Source=C:\temp\filename.xls;Extended Properties=Excel 8.0')...[listname$]