Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transfering Access 2000 mdb into Oracle 7/8
"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