Question: how to import data from excel file in toad?
Answer: Select the database connection on which you want to import data. ...  Select Tools | Import Export Data | Import Wizard. Use the Import Wizard to specify a data source and import options. ...  Click Finish to import the data and close the wizard.