Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
How to import data from Excel file to table using toad
The following are the steps to follow import data from Excel
sheet to and Oracle Table.
First the Table should exist with the same number of colums as that
in the excell sheet.
then in Toad. go to
Database--->Import--->Table Data
Then select the proper schema and Table name where in data should be inserted,
then click "Execute Wizard" where you can specify the type of file to
be imported.
pls select "Excel File (.xls)" and click next, after that give the
path of the file, and again click next and finally click execute.. and
your data will be transferred into the table as desired.
No comments:
Post a Comment