Excel File with more than 256 columns

  • 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

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Yes using CSV file can be a better.

  • 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.

  • 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

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

  • 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 😀

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 😀 ... yeah rite

  • 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:

  • 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