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

13 comments:

  1. 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. Yes Pratik We can use external table for this purpose. Details I will put in the next post. :)

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

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

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

    ReplyDelete
  6. Thanks for the info...

    ReplyDelete
  7. its really very helpful to beginners in oracle

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

    ReplyDelete
  9. At the end im getting file is not defined.

    Please help

    ReplyDelete
  10. 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. Yes, it helpful for beginners of migration.

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

    ReplyDelete