Post reply

Create Multiple Excel Files using Script Task Editor

  • July 7, 2009 at 6:23 am

    #134043

    Hi,

    I want to create multiple excel files dynamically through Script Task.

    In script task editor, I am trying to create an object of Excel.Application but unable due to Microsoft.Office library is not in references. When I tried to add reference, I couldn't find Microsft Excel 11.0 Object Library and also couldnt locate any option to add / import library in Script Task Editor.

    Is there any other way to create excel files dynamically?

    :rolleyes:

  • July 7, 2009 at 8:25 am

    #1021099

    Are the field names / types always the same, or do they need to be dynamic too?

  • July 7, 2009 at 8:28 am

    #1021103

    There is a thread here - and specifically a post by NaffMonk - that seems relevant to what you are trying to do.

    http://www.sqlservercentral.com/Forums/Topic531295-148-2.aspx

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

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