Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Import Data - Access to Oracle
Hi,
why don't you pump that stuff via ODBC into your Oracle-Database? You only have to install the sql*net client and the odbc-driver (from Oracle or Microsoft) on the client running the access-database. Then you can attach the oracle-tables in the Access database and fill them in Access as you would insert records into access-tables.
hth
Klaus
"Newbie (Joe)" <jranseth_at_hotmail.com> schrieb im Newsbeitrag
news:08775.359$Hs3.8127_at_news1.mts.net...
> 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 Sat Jul 01 2000 - 00:00:00 CDT
![]() |
![]() |