Re: Oracle and Access

Frederic Lavigne wrote:
>
> I had to retrieve data from Access to Oracle. How can i translate the
> Access database into an Oracle one ?
> the exp and imp tool are only for Oracle db ? Is there an equivalent
> under Access ?
> Can Oracle import table saved in ASCII ?
>
> If you got an anwser please mail me directly.
>
>
> Fred.
>
> ---
>
> Frederic Lavigne
> IUP Miage, Universite de Nice Sophia-Antipolis
>
> email: flavigne_at_clio.unice.fr
> web : http://clio.unice.fr/~flavigne

Oracle has the tool SQL*Loader. With this tool you are able to load ascii files in any format.
Have a look at the Oracle Documentation 'Server utilities'. There you can read how to use SQL*Loader.

Hope this helps.

Detlev

-- 
Detlev Goebel

mailto:detlev.goebel_at_gzs.de
---------------------------