Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006

    Unanswered: Export table to Excel

    Hi All,

    I would like to export a table to Excel and I haven't got a clue how to do it.

    1. Does anyone know how to do it through Toad?

    2. Or is there some sql command that exports table?

    I'm quiet a newnie as you might guess. No help from searching Google.



  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    In TOAD, execute a query. Right click on the output Data Grid and select "Save As". In Format block select "XLS File". Adjust additional options (if necessary), specify "File Name" in "Save to" block and that should be all.

    Without TOAD (or similar tool), spool the output as a comma separated values file (using, if possible, DBMS_OUTPUT package. If not, UTL_FILE). Open the CSV file using Excel.

  3. #3
    Join Date
    Nov 2006
    Thanks littlefoot. That was sweet and painless...

Posting Permissions

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