Re: MS Access 2000 with Oracle 8i

One option, if you have Designer installed, is to rev-engineer the Access DB, fix the constraints, sequences, triggers, etc. and create your Oracle DB from Designer. Then you can link the Oracle tables to Access and copy & paste the data into the new tables. Apply the triggers after the data has been moved and make sure to start your sequence numbers correctly to avoid errors.

Good Luck.

Joel

Fast wrote:

> hello,
> this is my first message in this NG.
>
> I have a installed Oracle 8i on my W2000 Server. I need to import a MS
> Access 2000 with multiple table in my DB Oracle. I have installed
> Migration Workbench: now I have SQl Server 6.5, 7.0 and Sysbase import
> driver, but not Access. Next step: on Oracle site I have downloaded
> Access Import driver for Migration Workbench, but this one runs only
> on Oracle 9 :-((
>
> Any idea?
>
> Stefano Falasconi
> Rome
Received on Fri Apr 12 2002 - 20:15:41 CDT