Thursday, October 7, 2010

Import data to Oracle APPS by TOAD

Database -> Import -> Table Data
-> Select Table name from Table drop down
-> Click on Show Data
-> Click on Execute Wizard
-> Select Excel File Radio Button
-> Click Next
-> Browse the Excel Sheet to be uploaded
-> Click on Next
-> Specify First Row as 2 (Row number from excel sheet, starting point to
retrieve data)
-> Click on Next
-> Click on Next
-> Match the Database columns with Excel columns
-> Click Next
-> Select the appropriate mode
-> Click on Execute

No comments:

Post a Comment