Transfer data from my oracle database to MS Excel

Asked By avah.hannah 30 points N/A Posted on - 08/23/2012

Hi all,

I 'm attempting to transfer data from my oracle database to MS Excel.

I found it difficult to select data from one and move it to the other

I also want to know how to match up the data IDs from one program to the other.

I have established the connection between the two, I think the SQL statement needs to be different but I am not sure.

Is there anyone who is good with SQL syntax that can help me?

• Status: Open
• Question Views: 939
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By reaiuhathy 0 points N/A #136059

Transfer data from my oracle database to MS Excel

Hello Avah,

Yes it is very difficult to transfer the data one by one. It takes time and effort, but it is possible really to export oracle data to excel. Here are the choices you can choose from:

1. You can use a package which can create Excel file for you basing on the Oracle database that you provide.

Have a look at this link:

Using ORA_EXCEL, you can format documents because of its features. It costs you 10 bux a year to use this package.

2. You can spool to an excel file. The code is very simple, all you have to do is run this script on the SQL prompt. Here's how it looks like:

                                 SQL> spool C:tempsample.tx

                                 SQL> select * from “table_name”

                                 SQL> spool off – don’t forget this line

In this example, you can view the exported file from the temp folder of your Local Disk C.

There you go, I hope that I was able to help you even a little.

Good luck!

Reaiu Hathy

 

About reaiuhathy

Questions
2

Answers
14

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/28/2012
• Question Category: Database