CODEWITHSUNDEEP
oracle-databaseexcelexport-to-excel
Rohit Verma
Rohit Verma

Reputation: 1821

Exporting data from Oracle query to excel using query

I am having a select query, the result of which i want to be exported in a excel file using Oracle query and not any in-built operations.

I am using TOAD for Oracle. I am not sure if this is possible or not.

Any help would be of great use.

Thanks in Advance!

Upvotes: 0

Views: 7417

Answers (2)

Robert Co
Robert Co

Reputation: 1715

Instead of pushing it into Excel, why not "pull" it into Excel? See get external data. An added bonus is that you can add this to your windows task scheduler that will update it for you.

http://office.microsoft.com/en-us/excel-help/connect-to-import-external-data-HP010089898.aspx

Upvotes: 1

Frank Schmitt
Frank Schmitt

Reputation: 30845

In Toad, it's pretty straightforward:

  • Run your query
  • click the "Export dataset" button
  • change export format to "Excel File"
  • enter a filename

Upvotes: 1

Related Questions