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

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

  • SSIS and SSRS will both do this.

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

  • 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