Printable View
There is an Oracle database that I do not have access to (not that I know anything about Oracle anyway) and we need an export of the data. The end goal is getting the data into Excel so my question is... A) Is it possible to extract data from an Oracle DB into another format that can be more easily imported into Excel (CSV, SQL, MS ACCESS, etc)? What other formats can I request from the admin? Is 3rd party software the only solution?
Thank you in advance,
Greg
You can use SQLPlus to spool results in comma delimited format. You can also query Oracle database from Excel directly if you have Excel query tool installed. It is under Data - Import External Data.
Thank you!
Based on your suggestion, does this article correctly describe the process, if we were to use Excel?
http://blog.mclaughlinsoftware.com/m...om-excel-2007/
Yes you can follow it.
Thank you skhanal!! We'll give this a shot. I just hope we don't have to resort to any 3rd Party software to get this done (if possible anyway).