N/APosted on - 08/23/2012
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?
Transfer data from my oracle database to MS Excel
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.