Post reply

SSIS to load complex Excel File

  • October 11, 2018 at 10:05 am

    #416053

    Hi,
    I want to load the below table into SQL Server Database using SSIS package. Can you one please tell me how to achieve this? I am quite struggling to load.

    Regards,
    Danny

  • November 5, 2018 at 1:47 pm

    #2012447

    My suggestion would be to use Macros to get your data into a normalized format and then attempt to import.

  • November 13, 2018 at 6:58 am

    #2013312

    dannyfirst80 - Thursday, October 11, 2018 10:05 AM

    Hi,
    I want to load the below table into SQL Server Database using SSIS package. Can you one please tell me how to achieve this? I am quite struggling to load.

    Regards,
    Danny

    To be honest, if that's the extent of your data, and there are no additional rows beyond row 13, then this would actually be easier to do with VBA in a macro, than to mess with SSIS.  You only have 33 values across just 13 columns.   The code to do that in VBA is relatively trivial, and you can probably find at least a template for your solution online just by searching for "VBA to import Excel spreadsheet into SQL Server".    You may need to learn a few things about the Excel Object Model, but it's not that difficult.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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