Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Access-to-Oracle

Re: Access-to-Oracle

From: Spark <nospam_at_hotmail.com>
Date: Tue, 8 Jan 2002 11:45:21 -0000
Message-ID: <3c3adbe4$0$231$ed9e5944@reading.news.pipex.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US