Post reply

creating excel sheet in sql server 2000

  • December 20, 2007 at 2:14 am

    #62758

    Hi All,

    Can anybody let me know how can i create a excel work book with 2 work sheets in it.

    later, i need to populate them with data present my table.

    Thanks in advance...!!!

  • December 20, 2007 at 2:18 am

    #761676

    You could try using the DTS Import/Export Wizard in SQL Server 2000, which would be the easiest way to transfer the data from your table to the Excel file

  • December 20, 2007 at 2:29 am

    #761678

    Hi Gogula,

    Apparently i need to create a stored procedure which i will be calling from my C++ code.

    First of all, i need to create a Excel sheet on the fly by calling this stored proc.

    Further, the better part is, i know how to populate it.

    Thanks

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

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