Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migration - MS Access2000 to Oracle8i?
Had the same problem Dipak.
SQL Loader requires you to write out configuration files to determine who, what, where and how it should understand the data being imported. In my opinion this is enough to break out the machine gun and mow ppl down :)
But seriously try using the beta program from oracle called workbench. It worked for me with no problems, no muss no fuss.
It's at;
http://technet.oracle.com/tech/migration/workbench/
Now if someone can tell me how to get Excel into an existing Oracle table. Or just into Oracle and then copy and paste the info into the existing table, that would be great!
Jack
Zhenming wrote:
> Try use SQL* Load
>
> Dipak Patel wrote in message <38B182F0.53EFCE73_at_uakron.edu>...
> >I have a database in Microsoft Access 2000 which I need to migrate into
> >Oracle 8i. Can I use anything in Enterprise Manager to do this? If so,
> >how?
> >Is there any other way I can migrate that database into Oracle 8i?
> >
> >thanks in advance,
> >Dipak
> >dpatel_at_uakron.edu
> >
Received on Tue Feb 22 2000 - 13:55:27 CST