Data Migration with Import Table Data option(Toad)

Data Migration with Import Table Data option(Toad)

CREATE TABLE TEMP_EMPLOYEE_DETAILS_MIG -- Data from Excel via Import Utility in Toad

(

  SEQNO           NUMBER(5),

  PERSON_ID       NUMBER(10),

  FULL_NAME       VARCHAR2(500 BYTE),

  DOJ             DATE,

  JOB_ID          NUMBER(10),

  PERSON_TYPE_ID  NUMBER(10),

  SUPERVISOR_ID   NUMBER(6)

)

Spreadsheet: Data from excel to the staging table (TEMP_EMPLOYEE_DETAILS_MIG)

Import Data from Excel Sheet:

Database -> Import - > Import table data

Select the table to which records has to be loaded.

2    Click on show data for existing records in the table

Execute Wizard to load records from excel to the table

Browse to load excel and finish the process to load records in the stage table