Is it possible to import an excel file into oracle using Toad?
You can import excel files into Oracle using Toad going to Database|Import|Import Table Data.
In this screen you have to select the Schema, Object Type,Object Name (in this example the table is example_table), commit mode and action.
Then click on 'Show Data' and then on 'Execute Wizard'.
In the next screen you have to select the File Format(Excel file) and click on Next.
Then you have to select the File that contains the data you would like to import (in this example is Sample.xls), then Click on Next (selecting the options that you need in Data Formats).
In the next screen you can check if toad has done the map correctly. If it is ok, then you can continue, otherwise you can modify or automap the columns.
In the next screen (summary) you can choose the Import mode and then click on Execute.
If you want to run an example you can create the following table
CREATE TABLE YOUR_USER.example_table
(
id NUMBER,
forename VARCHAR2(50),
lastname VARCHAR2(50),
age NUMBER
)
and an excel file with the following data:
1 John Smith 50
2 Maria Garcia 25
3 Peter Poj 22
For more information you can go to Help\Topics and type 'Import Wizard' on the Search tab.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center