Post reply

To export Data from Sql server to different tabs of Excel file

  • October 13, 2008 at 12:23 pm

    #199360

    we need to have reports that export to excel with multiple sheets.

    For making it simpler to understand :

    Select * from [tablename1]

    Select * from [tablename2]

    I need output of these two different statemants in two tabs of Excel sheet automatically.

  • October 13, 2008 at 12:40 pm

    #884297

    SSIS and SSRS will both do this.

  • October 13, 2008 at 12:50 pm

    #884305

    It would be great help for me if you can guide me step to step to perform this task.

  • October 13, 2008 at 3:23 pm

    #884345

    Currently i m using a SP setwebtask to get the data in two files but i want it in one single file in two different tabs.

    Need your expertise on this

    Thanks in advance

    Puneet

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

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