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

Home -> Community -> Usenet -> c.d.o.server -> Re: Transfering Access 2000 mdb into Oracle 7/8

Re: Transfering Access 2000 mdb into Oracle 7/8

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 5 Feb 2002 08:48:45 -0000
Message-ID: <3c5f9c73$0$230$ed9e5944@reading.news.pipex.net>


"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:3c5ee67a$0$18472$afc38c87_at_news.optusnet.com.au...
> It's hard!

<snip>
> Oracle used to supply a conversion utility, but you had to pay for it, and
> I've forgotten what it was called, and don't know whether it is still
> current (someone here will know). I tried it once or twice: you still
have
> to do quite a lot of work by hand afterwards, even so.

Oracle Migration Workbench, though I believe it doesn't yet support access 2000 file format so you might have to save down as access97 first. This will get you a most likely working version of your access database. I'd then strongly advise reworking half the conversion by hand.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Tue Feb 05 2002 - 02:48:45 CST

Original text of this message

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