Re: Import Data - Access to Oracle

You can also use migration toolkit provided by OTN.

Félix Eboué wrote:
>
> Use Acces File /export/ odbc
> Before , configure Odbc Oracle DSN to acces to your oracle's database;
>
> "Newbie (Joe)" wrote:
>
> > Thank you so far for all of your help, I come again with another basic
> > question.
> >
> > I have 2 tables from an access database that I need to import to Oracle.
> > How can I do this? Can the Migration Workbench import only 2 tables?
> >
> > What if I create the table structure in Oracle and import the
> > data....how do I do this? I assume that I can use a .csv file, but is there
> > a tool that helps me with this, or do I have to do it in SQL*PLus? I have
> > heard of SQL Loader - what is it, and how can it help my situation?
> >
> > My apologies if this is too basic. I am brand new at the back-end of
> > databases and would appreciate some help (detailed, preferrably *g*)
> >
> > Thanks in advance!!
> >
> > -Joe

-- 
Breno de Avellar Gomes 
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
EC Municipio
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular phone: 351-917383469
Cellular messages: 917383469_at_sms.telecel.pt
ICQ # 35567342

Toll free fax and answering machine from USA
1-888-EXCITE2  extension  291-303-8152

Outside USA (international fares apply)
1-917-463-3173