Search This Blog

Tuesday, November 30, 2010

Loading Data from Excel to Oracle Tables using TOAD

Follow the below steps to load data from Excel sheet to Oracle tables. This can be used wile data migration.
Step 1: Put your data in Excel Sheet. Remove column headers.


Step 2: Create Table in Oracle. Take care of Column data types

CREATE TABLE XX_TEST
(EMPLOYEE_NO NUMBER,
 ENAME       VARCHAR2 (50),
 SALARY       NUMBER
);
Step 3:
Step 4: Select the XX_TEST table and press on Show Data button.






Step 5 : Commit
Posted by at
Labels:

13 comments:

  1. pratik gargNovember 30, 2010 at 9:28 PM

    can we do the above by using only SQL command.
    means without using TOAD or any other tool, just by using Oracle database management system??

    ReplyDelete
  2. Sandip JadhavNovember 30, 2010 at 10:08 PM

    Yes Pratik We can use external table for this purpose. Details I will put in the next post. :)

    ReplyDelete
  3. Sandip JadhavDecember 1, 2010 at 2:59 AM

    Dear Pratik,
    Please check
    http://oracleprasan.blogspot.com/2010/12/external-tables-import-data-to-oracle.html

    ReplyDelete
  4. AishwaryaAugust 19, 2011 at 2:32 PM

    hey thanks for the info..its really helpful..

    ReplyDelete
  5. AnonymousJanuary 18, 2012 at 7:58 PM

    This option is not there in all TOAD versions, please list versions in which it is available

    ReplyDelete
  6. NavabApril 13, 2012 at 11:01 PM

    Thanks for the info...

    ReplyDelete
  7. AnonymousJanuary 28, 2013 at 11:26 PM

    its really very helpful to beginners in oracle

    ReplyDelete
  8. AnonymousJune 13, 2013 at 8:37 AM

    yeah it is not available for toad 7.4 version can please tell me from which version we can do this

    ReplyDelete
  9. UnknownJuly 8, 2013 at 7:41 AM

    At the end im getting file is not defined.

    Please help

    ReplyDelete
  10. UnknownFebruary 10, 2014 at 10:34 PM

    sorry sir, i have small problem, i dnt have in the toad import under import data is not there sir, then wat to do sir..

    ReplyDelete
  11. UnknownJanuary 7, 2016 at 2:40 AM

    Yes, it helpful for beginners of migration.

    ReplyDelete
  12. Ahsan JavedMarch 14, 2016 at 6:46 AM

    i am trying but my toad is giving error "list index out of bounds(-1)" please help

    ReplyDelete
  13. yanmaneeeMarch 18, 2020 at 6:27 AM

    air max 95
    supreme clothing
    golden goose outlet
    nmd
    retro jordans
    air max 270
    yeezy shoes
    kyrie spongebob
    michael kors handbags outlet
    nike shoes

    ReplyDelete

Subscribe to: Post Comments (Atom)