IMPOTED Excel/Text File Data USING TOAD

IMPOTED Excel/Text File Data Into Oracle Table Using TOAD

Step 1 : Open TOAD.

Step 2 : Write the following query to create a test table: 

1. Create table TESTTABLE   
2. (  
3. NAME varchar2(20),  
4. Address varchar2(100),  
5. RollNo integer  
6. )  

Step 3 : Now my table is ready. It's time to create the data in an Excel file.


Step 4 : Go to Database -> Import -> Table Data. 

Step 5 : Select the table you want to import the Excel data to.



Step 6 : Click on show data. Now execute the data button to enable the use. Click on that.

Step 7 : After clicking on Execute Wizard the following screen will open:



Next ->



Step 8 : Now, browse to your Excel file - > Next ->



Next ->



Step 9 : Choose the sheet and click on AutoMap. The AutoMap button will automatically bind your Excel sheet column data with the Oracle table column. 

Next ->



Next ->



Here your Excel data has been bound with the table columns. Next ->



Step 10 : Click on Execute to finish the process. It may ask for sheet selection. Click on Okay with the desired sheet.



Here is your uploaded data:



Step 11 : Commit the Task by clicking on the commit button.