Sunday, 10 February 2013

TOAD- Import data from Excel sheet to an Oracle Table Using Toad

First the Table must exist with the same or equal number of columns as that in the excel sheet.
Now from TOAD go to:

1. Database-->Import-->Table Data
2. Select the proper schema and Table name where data should be inserted
3. Click "Execute Wizard" and specify the type of file to be imported
4. Select "Excel File (.xls)" and click next
5. Give the path of the file, and again click next
6. Finally click execute..

Now your Excel sheet data will be transferred or imported into the oracle table.