How to create an Excel spreadsheet from an Oracle database

1160675 pts.
Tags:
Microsoft Excel
Oracle
Oracle Database
I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

SSIS is a SQL Server tool.

From SQL Developer you can export the data from your table, or the results of a complex query, to Excel.

If you want to do it from code, you will most likely need to use the UTL_FILE package.  Without any third party tool you could write CSV files, that you can later open with Excel.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: