Toad World® Forums

Exporting EXCEL

Could anyone of you brainy guys be good enough to let me know the steps, to upload a simple Excel File to Oracle?


Open schema browser and go to the table’s tab. Choose create table –
note button on bottom of create table screen that says load columns from file.
Press that button and choose your excel file – Toad will open that file
and use the column headers as the names for the table columns. Press OK to
create table. Refresh the schema browser so that new table shows up. Right hand
mouse on it and choose import data. In that wizard simply choose the new table
you created and the excel file and that’s it J