Post reply

load table to excel file different sheets

  • July 22, 2012 at 1:55 am

    #278267

    Hi

    This is vivek.I have one requirement load table data(1000 records) to excel file but each sheet allow 100 records only .Please give me steps how to load it .It is urgent requirement.

    Thanks&Records,

    vivek,

    viveksvkola@gmail.com:w00t:

  • July 22, 2012 at 2:25 am

    #1515944

    Hi Vivek...I am confident that this can be done with SSIS easily. Kindly explore.

    -Lokesh

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • July 22, 2012 at 3:04 am

    #1515947

    the following may work as well, suggesting the workaround since you mentioned that it was urgent.

    Execute "Select * from Tablename" in SQL Server Management studio query editor window(if it is not too large) and then

    1) copy the data (with header) and paste it in excel sheet.

    or

    2) save the results as CSV format and then open the CSV file in excel.

    but i would still like to think that Lokesh's suggestion of using SSIS would be more appropriate, sophisticated and more importantly error proof as well.

  • July 22, 2012 at 11:48 am

    #1516003

    i want clarity more

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

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