I have an oracle .dmp file which I would like to open from excel 2007. How do I use the 'get external data' feature to do so? Is it possible in the first place?
Asked
Active
Viewed 5,047 times
1 Answers
4
It's not possible, no.
Assuming the .dmp file was produced by the Oracle export utility, that is a proprietary, undocumented binary file. Only Oracle's import utility would be able to read it. The import utility can dump the DDL statements for the structure(s) in the dump file to a flat file but if you want to look at the data, you'd need to import that data into an Oracle database.
Justin Cave
- 227,342
- 24
- 367
- 384
-
Some tools exist (didn't find free ones, but) : http://www.convert-in.com/ord2xls.htm – Raphaël Althaus Apr 19 '13 at 11:53