Post reply

Excel File with more than 256 columns

  • August 9, 2013 at 10:23 am

    #278466

    Hi All,

    I have an excel file with more than 256 columns. And the current driver (Jet OLEDb) doesnt supports that, it can read till 256 columns.

    Please let me know how to load the data from the excel file to a sql table usiing SSIS 2005.

    Thanks

    Sam

  • August 11, 2013 at 11:40 pm

    #1640443

    You could try outputting to a CSV file and then importing that.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • August 12, 2013 at 3:41 am

    #1640491

    Yes using CSV file can be a better.

  • August 12, 2013 at 5:45 am

    #1640517

    CSV files can also alleviate some headaches from newer versions of Excel, which don't always play so well with SSIS 2005.

    ____________
    Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.

  • August 12, 2013 at 5:50 am

    #1640519

    lshanahan (8/12/2013)

    CSV files can also alleviate some headaches from newer versions of Excel, which don't always play so well with SSIS 2005.

    The older versions of Excel also don't play nice with Excel 😉

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

  • August 12, 2013 at 6:06 am

    #1640526

    For Some reason ... Excel and SSIS dont really like each other 🙂

  • August 12, 2013 at 6:46 am

    #1640550

    twin.devil (8/12/2013)

    For Some reason ... Excel and SSIS dont really like each other 🙂

    It's because Excel thinks it knows what you want: so that even when you ask for something specific, it gives you what it thinks you want, not what you asked for.

    This seems to suit accountants 😀

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • August 19, 2013 at 8:36 am

    #1642725

    😀 ... yeah rite

  • August 20, 2013 at 8:55 am

    #1643106

    Phil Parkin (8/12/2013)

    twin.devil (8/12/2013)

    For Some reason ... Excel and SSIS dont really like each other 🙂

    It's because Excel thinks it knows what you want: so that even when you ask for something specific, it gives you what it thinks you want, not what you asked for.

    This seems to suit accountants 😀

    Amen to that.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • September 7, 2013 at 7:40 am

    #1648331

    Hi Sam,

    If you can use third-party solutions, check the commercial COZYROC SSIS+[/url] library. It contains Excel adapters which support more than 256 columns.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 10 posts - 1 through 9 (of 9 total)

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