Import Issues - Excel

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply