DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Data Load

  1. #1
    Join Date
    Jan 2001
    Posts
    20

    Question External data load

    Dear All,

    I was wondering how I can load data from MS Excel, Access to Oracle DB except for Oracle SQL*Loader. Thank you for your help in advance!!


  2. #2
    Join Date
    Dec 2001
    Posts
    221
    USE ODBC.

    1. see that you have installed either -
    Micrsoft ODBC for Oracle or
    ORacle ODBC driver

    2. Create DSN using controlfile.
    3. You can create an UDL file for testing.
    4. If succeded. use this DSN to export data to Oracle table from MSAccess.

    for Excel , you can import data into MSACCESS and the follow above procedure
    Santosh Jadhav
    8i OCP DBA

  3. #3
    Join Date
    Jan 2001
    Posts
    20

    Thumbs up

    Thank you!! Santosh

    I did successfully import the external data into Oracle DB.
    However, something weird happened...

    In TOAD, I can see the import schema & data, but..................
    In Sql*Plus, I issue "select table_name from user_tables" from that owner. It did display the new-added table name --NEW, but after I run " select * from NEW or desc NEW, I got the error message: ORA-00942: table or view does not exist.....

    Any ideas for all of you ?? Thank you a million!!




    [Edited by peggy on 05-23-2002 at 05:19 AM]

  4. #4
    Join Date
    Dec 2001
    Posts
    221
    may be when you exported the tables into oracle the table names are in small case or (initcap) , it would have taken the same.

    instead, try to use

    select * from "NEW"

    it should work.
    Santosh Jadhav
    8i OCP DBA

  5. #5
    Join Date
    Jan 2001
    Posts
    20

    Smile

    Thank you so much!! Santosh

    It did work, and I do learn a lot....& appreciate for your time & effort......



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width