Monday, 21 May 2012

How to Import Excel sheet data to Oracle

Without Toad or an tool :
  1. Save the file as .csv file, then load the file into oracle using sqlLoader.Multiple sheets does not matter how the records are listed matters and how that should go into the db matters.

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

No comments:

Post a Comment