Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Access-to-Oracle
you can download the migration workbench from
http://otn.oracle.com/software/tech/migration/workbench/content.html
or just go the download page at oracle's site, choose the right-hand
drop-down list and search through that one (the utilities and drivers
one).
Dan Barron wrote:
>
> A common question I'm sure, but here goes...
>
> I'm an experienced DBA who is using Oracle for the first time. I have
> a couple of Access databases to convert and was wondering what you all
> think is the best way to accomplish this. The databases are Access
> 2000 databases and my Oracle 8i version is 8.1.7.0.0.
>
> I read about a Migration Assistant, but it seemed limited Access 97
> plus I couldn't find it anywhere to download. Is the MA the best way?
> I could write an SQL script to create the tables, etc. and then export
> the data to text files and import, but that seems like a lot of work.
> I've tried the "Export" command in Access, but the results are not
> satisfactory (it seems very stupid about data types, for one thing.)
>
> Any help or pointers to information as to the best way to accomplish
> this would be much appreciated.
>
> dan
>
> Dan Barron
> ACP-ASIM
> dbarron_at_mail.acponline.org
Received on Mon Jan 07 2002 - 15:08:46 CST