Home Forums SQL Server 2005 SQL Server 2005 Integration Services Using SSIS to export data from SQL 2005 to Excel 2007 RE: Using SSIS to export data from SQL 2005 to Excel 2007

  • April 2, 2008 at 2:03 pm

    #797498

    I hope you are aware that Excel 2007 is based on XML ... so far this is the only documentation I was able to find that appears to have a bearing on what you are attempting to do

    How to connect Excel to SQL Server 2005 Analysis Services:

    http://support.microsoft.com/kb/940167

    Hope this helps

    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]