Import Issues - Excel

• swoozie

  SSCrazy

  Points: 2770

  More actions

  November 13, 2013 at 1:10 pm

  #279145

  I am sure this is somewhere on this forum, but I haven't been able to find the right combination of words for the search.

  I am trying to import a spreadsheet. the first 5 rows and 260 columns are the header map to column names. The issue I am having is with a column that contains dates in rows 6+

  It is the 2nd column, 2nd and 3rd row. The data is "submitted date" in both the 2 & 3 rows and date time stamps in rows 5+

  When I am trying to import it, the header "submitted date" is coming across as a NULL

  I have had this issue a long time ago, and I can not remember the fix.

  Could someone please point me in the right direction?

  Thanks,

  Susan

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  November 13, 2013 at 2:15 pm

  #1666209

  Screenshot?

  Also take a look at this blog post of mine:

  What’s the deal with Excel & SSIS?

  It covers most of the common issues with Excel and SSIS.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP