How can you import data from an Excel sheet or query another table and have Toad automatically create a corresponding table to insert these values into? I would like to insert data from an Excel file or from a query against another table into Oracle without having to pre-create the table.
Use Tools | Import | Import Wizard. In the Wizard, select the file or enter the query to be run, and it will give a preview and mapping of the data. Then near the end of the wizard, it will give 2 options for a target database table. Choose to insert into a single new table, which will create a new table based off of the Excel file or queried data being imported (header title from the first row in the Excel).
Give it a new table name, select the schema and by default it creates the columns as NVARCHAR. After it execute it should give you a report window noting if the data was imported, how many rows, or if there was an error.
