How to export sql server data into multiple excel sheets ?

  • yes,

    you can mail using OSQL command and Vmailer exe file

    Cheers

    RB

  • Hi,

    This is sekhar

    please send step by step process for how split the data into multiple excel sheets in single excelfile using ssis

    regards

    sekhar

  • Interesting idea, let me try that. I have a very similar requirement. I want to generate a spreadsheet with many worksheets, but I don't want to manually create a template Excel. I want to create it from the queries. If needed, I can create views for every query.

  • Hello,

    Do you want to export data in one table or different tables to multiple sheets?

    If the later one, you can create a template file, which the first sheet is used to save data in one table, while the second saves data in other. And then export data.

    There is a simple example. Please have a look.

    http://www.c-sharpcorner.com/UploadFile/d2dcfc/C-Sharp-create-excel-report-chart-contained-with-mark-designe/

    [/url]

    Hope helpful!

    Day after Day, Tomorrow is...
    E-ICEBLUE[/url]

Viewing 4 posts - 31 through 33 (of 33 total)

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