Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Access-to-Oracle
Dan,
I have used the utility on anumber of occassions. I have found it straight
forward and logical. I would recommend it.
"Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message
news:3C3A0DF7.5C9E58C7_at_shaw.ca...
> 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 Tue Jan 08 2002 - 05:45:21 CST
![]() |
![]() |