Post reply

Export data into Existing Excel File

  • July 8, 2013 at 7:55 am

    #279968

    I am returing data into TableVariables using Cursors .So I am having data for Each date of month .

    I want this data to be exported to existing EXCEL and new tab for Each Date of month.

    Can anyone help me out with this.

  • July 8, 2013 at 8:02 am

    #1630451

    Rakesh.Chaudhary (7/8/2013)

    I am returing data into TableVariables using Cursors .So I am having data for Each date of month .

    I want this data to be exported to existing EXCEL and new tab for Each Date of month.

    Can anyone help me out with this.

    via TSQL or SSIS?

    for TSQL, the excel sheet must have all tabs already created; you cannot create new worksheets via TSQL, as far as I know.

    From there, you can use a linked server or openquery to insert into the sheets.

    INSERT INTO MyLinkedExcel...July$

    SELECT ColumnList From MySQLTable

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 8, 2013 at 8:09 am

    #1630455

    Thanks !!!!!

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

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