Re: Importing into Oracle from Access

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Mon, 04 Dec 2000 15:38:53 -0500
Message-ID: <3A2C00DD.C195B78F@Unforgetable.com>

Jerry wrote:

> How would I import data from an Access table to an
> Oracle database. Step by step.
>
> thanks

2. Export the data from access to a delimited file. Some people prefer comma-separated-values and others prefer the pipe character. It doesn't matter as long as the delimiter never appears in actual data.

3. Copy the resultant file to the machine where the Oracle database is located.

4. Use SqlLoader to load the data into Oracle. Received on Mon Dec 04 2000 - 14:38:53 CST