Results 1 to 5 of 5

Thread: Load excel sheet on already existing table with data on oracle table using TOAD

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    Load excel sheet on already existing table with data on oracle table using TOAD

    Hieyguys i need to load some excel sheet on Oracle Table using TOAD, i know there is a wizard.

    If some can give me step by step i will appreciate.

    Hints: The table has data, i just want to add some more data

    Thanks

  2. #2
    Join Date
    Oct 2005
    Posts
    2,557
    You can't read the help in TOAD? Tells you step by step what to do.

  3. #3
    Join Date
    Jan 2007
    Posts
    36
    I got it , i just try with a dummy excel file and check out all the process after i figured out i didi with the actual file and drop the dummy table i created for testing.

    we do not have test enviroment.

  4. #4
    Join Date
    Dec 2008
    Posts
    1

    Import data from excel into the database (already contains data)

    HI ,
    Could you just tell me how you had imported data from excel sheet to a database already containing data ,using Toad

    Please help

  5. #5
    Join Date
    Oct 2006
    Location
    Denver
    Posts
    4
    You just right click on the table and click on the 'Import From ....". If you click on the 'Show Data' button it shows data already loaded then you can run the wizard to import more.

Posting Permissions

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