|
-
Export Oracle DB to CSV, etc?
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/
-
-
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).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote