Not getting last column of excel while Importing into SQL table

• rhythm.varshney

  Ten Centuries

  Points: 1138

  More actions

  June 27, 2013 at 1:37 am

  #279619

  I am importing an excel having 5 columns into a SQL table.

  Howevevr I am not able to see last column of excel in Excel Source Editor neither in columns nor in preview.

  Please suggest.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 29, 2013 at 4:46 am

  #1628485

  It could be a lot of things. Post your Excel file, attach it to this thread.

  An alternative is to export your Excel file as a csv file and import that using SSIS.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato