Excel to SQL2005

• Jp

  Default port

  Points: 1419

  More actions

  February 7, 2007 at 5:48 am

  #115509

  Hi,

  I am trying to import data from Excel to SQl2005,sp1 table.

  Excel has col with cells are formatted as 'General' and with sample data:

  1

  1.01

  1.02,

  11A1

  12D9

  The import runs fine but it excludes data values 11A1,12D9 etc..

  The destination col is varchar(10).

  I also tried formatting excel cells as text but no success.

  Any idea what needs to be done to import the alphanumeric data.

  Thanks for your help.

  Jp

• Ashwin Mahajan-392813

  Valued Member

  Points: 59

  More actions

  February 8, 2007 at 7:21 am

  #688558

  You could try editing the extended properties of the OLE DB Excel Connection and add IMEX=1.