Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Location
    Chennai
    Posts
    21

    Unanswered: Exporting stored procedure result set to an excel sheet

    Hi,

    I', new to sybase database

    I have to export the output result set of a sybase stored procedure to an excel sheet

    Please somebody can help me regarding this

    Thanks,
    Satish

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    It would be easier to just run the proc from excel.
    Create an odbc data source
    From excel click Data, Import external data, New database query
    Choose your data source
    Close the add table box
    Click on sql
    and enter
    exec myproc
    for the sql
    click File, return data

  3. #3
    Join Date
    Jun 2008
    Location
    Chennai
    Posts
    21
    Thank you vey much !!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •