In article <36C13BD8.EEC260CA_at_berlin.de>, r.schulz_at_berlin.de says...
> look here
> ftp://ftp.oracle.com/pub/www/ckit8/accss2o8.exe
> or
> http://www.oracle.com/products/free_software/index.html#ckit8 (the same
> plus docs)
> it´s an excellent tool for migration form MS-Access to Oracle 7/8!
> cheers
>
> D.M.(Mike) Mattix schrieb:
>
> > In article <79pg96$69q$1_at_nnrp1.dejanews.com>, dhtn_at_hotmail.com says...
> > > Greetings,
> > > Is there any 3rd party software for migrating data from Access to Oracle?
> > > What is your experience doing this, what to watch out for?
> > > Many thanks!
> > >
> > > -----------== Posted via Deja News, The Discussion Network ==----------
> > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> > >
> > I have experimenting with the Access to Oracle Migration java applet. It
> > seems to have some holes in it. I especially don't like the idea of it
> > ignoring the QueryDefs set up in Access. I have been experimenting with
> > a VBA module to extract the QueryDefs, edit the SQl, and modify it to
> > work against Oracle (eliminate variables with whitespace, DISTINCTROW
> > keywords, etc).
> >
> > Is there anything better out there canned and running already??
> >
> > thanks
> >
> > Mike Mattix
> > dmmattix_at_earthlink.net
>
>
>
> --
> b e r l i n . d e - der onlinedienst der stadt
> ________________________________________________________
> Primus-Online Berlin-Brandenburg GmbH & Co. KG
> debis Haus am Potsdamer Platz
> 10875 Berlin
>
> Rüdiger J. Schulz
> Technik
>
> tel: +49 (30) 2554-1497
> fax: +49 (30) 2554-3725
> email: r.schulz_at_berlin.de
> homepage: http://www.berlin.de
>
That is the java applet I am using, it comes with Oracle 8. It still has
the limitations I was referring to. I have migrated to a VB app that
will strip out the DISTINCTROW and white spaced column names (and
alias's). I will continue work to also have it attempt to create the
view by connecting to the Oracle instance and executing the created sql.
Mike Mattix
dmmattix_at_earthlink.net
Received on Wed Feb 10 1999 - 21:45:57 CST
