Post reply

Connection manager for excel version 2007

  • January 15, 2009 at 3:39 am

    #155131

    Hi,

    I'd like to export table with more 66 000 rows to excel 2007.

    In SSIS connection manager setings - if I chose excel I can't find option to select excel 2007.

    There is only 97-2005. Does anyone know some update location to have option(upgrade) in order to get excel 2007 in connection manager?

  • January 15, 2009 at 10:22 am

    #927525

    Jagger (1/15/2009)

    Hi,

    I'd like to export table with more 66 000 rows to excel 2007.

    In SSIS connection manager setings - if I chose excel I can't find option to select excel 2007.

    There is only 97-2005. Does anyone know some update location to have option(upgrade) in order to get excel 2007 in connection manager?

    Check this article. You have to use different connection manager.

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

  • January 15, 2009 at 11:14 am

    #927564

    You might want to read this and the do the download as well as follow CozyRoc's link.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

    From the above url:

    This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files. Connectivity to text files is also supported.

    ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • January 16, 2009 at 5:02 am

    #927964

    Thank you. It works fine. : )

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

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