SQL Developer for importing from Excel

Question

Hi

I have installed SQL Developer in my system, but how can i utilize the GUI. I am new to this and i want to import datas from Excel to Oracle database using SQL Developer

Thanks in advance

Answer 1

At what point did you get stuck? A fast track:

1. Create a connection to the database in SQL Developer
2. Create a table as a destination for the xls data
3. save excel data as csv
4. right click on the table from step 2
5. select 'import data'
6. select csv file
7. use the wizzard

and bob is your uncle