Re: Exporting Access data/import to Oracle

From: Oracle DBA <robin.b.franklin_at_boeing.com>
Date: 1998/06/08
Message-ID: <Eu8r4s.ty@news.boeing.com>#1/1

You can install the Oracle's wizard migration tool ( from Access to Oracle) from the Oracle installation CD ROM. With this tool, you can migrate any Access's database into Oracle's database. It'll provide you two options: Migrate/convert the database's objects only or migrate with objects plus data. The product then created the new objects(table, view, etc...) in Oracle database

from the Access database
If the objects is already existed in Oracle. I suggested that you migrated the Access database (+ data) into Oracle with a new object's name, then using SQL*Plus and do the " insert into existing_table ( select ...... from new_table);"
command.

Good luck,

bmolish_at_my-dejanews.com wrote:

> Has anyone exported an Access database and imported into an Oracle database?
> We currently are using Oracle 7.3.2 on an HP UX box.
> We are also using Access 97...
>
> Could you please provide me with the step and any usefull information.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Jun 08 1998 - 00:00:00 CDT