Export/Import data from/to Oracle/Excel table using toad
Export data from oracle table to xl using toad
1. Fire up Toad and connect to database
2. Execute command in editor & press export dataset (green button) eg
select * from schema.table;
3. Press ok generates xl report of this table (multiple export formats available)
Import data from xl to oracle table using toad
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.
Export data from oracle table to xl using toad
1. Fire up Toad and connect to database
2. Execute command in editor & press export dataset (green button) eg
select * from schema.table;
3. Press ok generates xl report of this table (multiple export formats available)
Import data from xl to oracle table using toad
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.
No comments:
Post a Comment