Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Import Data - Access to Oracle

Import Data - Access to Oracle

From: Newbie \(Joe\) <jranseth_at_hotmail.com>
Date: 2000/06/30
Message-ID: <08775.359$Hs3.8127@news1.mts.net>#1/1

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 Fri Jun 30 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US