Re: Copying dBase to Oracle

From: <mandrew_at_my-dejanews.com>
Date: Wed, 03 Jun 1998 13:01:16 GMT
Message-ID: <6l3her$3lh$1@nnrp1.dejanews.com>

In article <6l2q5d$75o$1_at_nnrp1.dejanews.com>, bonanos_at_yahoo.com wrote:
>
>
> > I want to convert a database from dBase to Oracle (7.3).
> > What is the best methode to perform this conversion?
>
> There are a couple of ways to do this:
>
> 1. You can import the dBase file into MS Access and export as a delimited text
> file.Then create the table in Oracle and import it using sqlldr73.
> sqlldr is oracles text loading utitility. You will find examples (.ctl) in
> <oracleroot>\rdbms73\loader\
>
> 2. You can import the file into access. Create the table in Oracle, Link the
> table in access via ODBC and then copy from dbase data to Oracle inked
> table.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

Visual DBase also has a way to directly export text delimited files.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 03 1998 - 08:01:16 CDT