Post reply

Export data from SQL server to multiple tabs

  • August 31, 2016 at 8:02 am

    #329637

    Hi,

    Is it is possible to export data from SQL server to multiple tabs?

    Say i am having 5 tables

    i need all the data in single excel with 5 sheets filled .

  • August 31, 2016 at 12:06 pm

    #1898624

    Evidently it's possible. I see some articles out there on point.

    Google all of these at once: MSDN TSQL EXCEL EXPORT MULTIPLE TABS

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • August 31, 2016 at 12:41 pm

    #1898630

    It's possible to do this with SSIS, but SSIS is complicated enough that I would not recommend trying this as your first SSIS project.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

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

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