Re: [Oracle / Access]

I'd take a look at XML. I don't know if Access and Oracle are ready yet, but in theory XML should make this sort of thing very easy. Mike

Kelly Wilcox <tcwilck_at_tc.cc.va.us> wrote in message news:veM45.23895$ds.697772_at_newsread2.prod.itd.earthlink.net...
> This may not be the best approach, but here's what I do:
>
> 1. Open up your Access DB
> 2. Create tables on Oracle to mirror the tables in Access
> 3. Create Insert Queries in Access to copy the data
>
> Anyone else? I have to do this every now and again myself - is anybody
 else
> using a different method?
>
> hth,
> Kelly Wilcox
>
> EECKEMAN Jérémie wrote in message ...
> >I would like to import a microsoft access database to Oracle Server...
> >
> >Does anyone can send me documentation or tips ?
> >
> >Thanks !
> >
> >
> >-----------------------------
> >Jérémie Eeckeman
> >Systems Developper
> >
> >Framfab
> >76, avenue Pierre Brossolette
> >92440 Malakoff
> >
> >tel : 01-55-48-11-00
> >fax : 01-47-35-00-00
> >http://www.framfab.fr
> >mailto : jeeckeman_at_framfab.fr
> >
> >
> >
>
>
Received on Sat Jun 24 2000 - 00:00:00 CDT