XLS file importing are there defaults im missing?

• JAREDMOFTAH

  SSC Enthusiast

  Points: 148

  More actions

  October 27, 2008 at 11:59 pm

  #383246

  Hello All,

  I have a question regading XLS & Importing/ the defaulting of the data type.

  I am importing data from a xls speadsheet and one of the columns (ID) starts off displaying 123a then will revert back numbers like 1234 later down the column

  123a

  1234

  12345

  12346

  12347

  etc

  the problem is when i display this in a SELECT rowset query i get the following displayed:

  123a

  NULL

  NULL

  NULL

  NULL

  I have tried using a CASE to Convert 123a to a varchar then the rest to INT but that doesnt work either..

  Thanks for your help

• JAREDMOFTAH

  SSC Enthusiast

  Points: 148

  More actions

  October 28, 2008 at 1:20 am

  #890422

  IMEX = 1

  🙂