yjh123
asked on
ORACLE DBF to MS ACCESS
This may sound really dumb so please excuse my ignorance.
I have a ORACLE DBF database in an old UNIX system and I don't even know which one is the main DB. I want to read this ORACLE database and somehow parse into my own program or import into ACCESS. The size of the DB is about 2 G. There are so many pre-bulit shell scripts that create reports. But none of them create the report I need. Of course I don't have much idea about the oracle scripts, but I can program in shell or C.
What's the best way to understand this big DBF file and get ready to parse into MS ACCESS or my own program? Since I cannot program SQL scripts, I want to parse the DB into my program and manipulate the data the way I want it with my program. (If it is doable)
I really appreciate your suggestions.
YJH
hongsuk@rcf.usc.edu
I have a ORACLE DBF database in an old UNIX system and I don't even know which one is the main DB. I want to read this ORACLE database and somehow parse into my own program or import into ACCESS. The size of the DB is about 2 G. There are so many pre-bulit shell scripts that create reports. But none of them create the report I need. Of course I don't have much idea about the oracle scripts, but I can program in shell or C.
What's the best way to understand this big DBF file and get ready to parse into MS ACCESS or my own program? Since I cannot program SQL scripts, I want to parse the DB into my program and manipulate the data the way I want it with my program. (If it is doable)
I really appreciate your suggestions.
YJH
hongsuk@rcf.usc.edu
ASKER
Adjusted points to 150
hi yjh123,
if you have an oracle ODBC-Driver you can import to access as follows:
make sure that the oracle-odbc driver configured properly.
Open access, create a new db, choose on tables new, choose table-import, choose as filetyp ODBC databases, select your oracle ODBC-Driver, login, choose select all, OK.
All Oracle-Tables should be now imported.
meikl
if you have an oracle ODBC-Driver you can import to access as follows:
make sure that the oracle-odbc driver configured properly.
Open access, create a new db, choose on tables new, choose table-import, choose as filetyp ODBC databases, select your oracle ODBC-Driver, login, choose select all, OK.
All Oracle-Tables should be now imported.
meikl
If you know the tables that you might interest, you can extract
data from it with simple SQL:
unload tablename to "filename.dat"
the result is a ASCII delimited file that you can import into ACCESS in a moment
data from it with simple SQL:
unload tablename to "filename.dat"
the result is a ASCII delimited file that you can import into ACCESS in a moment
If you can connect to Oracle (open SQL session), then try
to make a spool into text file:
sql>
sql> spool on yourfile.txt
sql> SELECT * FROM yourtable;
sql> spool off
Then you can import or manipulate this text file.
to make a spool into text file:
sql>
sql> spool on yourfile.txt
sql> SELECT * FROM yourtable;
sql> spool off
Then you can import or manipulate this text file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER