Transfering dBase files to Oracle

[PJH]

Briefly, what is involved in transferring dBase IV files to Oracle 8 database?

 

[ikosolap]

Ok,<br>
this is how we did it as far as i remember, 'cause it was rather long ago...<br>
<br>
you install Oracle Open Client Adapter for ODBC. Generally, it allows you to connect to ODBC-compliant databases from Oracle proprietary tools, e.g. Dev2000, _but_ this product includes a testing utility, ubt.exe, which has a special command to copy tables across different ODBC datasources and Oracle connections. So you use that utility to copy tables from dBase to Oracle.<br>
<br>
For furhter details, see documentation.

 

[kalyan]

If it is not a very regular process. Open dbase file with excel and save as CSV. Using SQL loader, you can load into the Oracle database.

 

[mickbarelo]

What is it is a regular process.

I need to be able to take data from a dbf, query and amend it, then write it back to the dbf.

Any ideas welcome.

Cheers

 

[rcurva]

You must research something about Oracle's Heterogenous Services or Generic Connectivity using ODBC Option.

http://www.oracle.com/gateways/

Robbie

&quot;The rule is, not to besiege walled cities if it can possibly be avoided&quot; -- Art of War