Re: Import Data - Access to Oracle

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
Received on Thu Jul 06 2000 - 00:00:00 CDT