How to import excel sheet to create table with data in the excel sheet.

Naveen Upadhye

how to import excel sheet data to create a table with data into it.

example;

thatJeffSmith-Oracle

Step by step instructions here

https://www.thatjeffsmith.com/archive/2012/08/how-to-import-from-excel-to-a-new-oracle-table-with-sql-developer/

Alex Nuijten

It depends, what client are you using? SQLCL, SQL*Plus, SQL Developer, APEX, TOAD, PL/SQL Developer....

Naveen Upadhye

Hi Alex,

Its

Oracle sql devoloper

Alex Nuijten

In the navigator, right click on "Tables", select "Import Data" and follow the wizard

Naveen Upadhye

Hello Alex.

I didn't find the navigator component.

Can I know where exactly it comes?

Frank Kulash

Hi, @User_XDYKE

Since this question is about SQL Developer, and not SQL or PL/SQL, then it should be in the

SQL Developer — oracle-tech

space, not the SQL and PL/SQL space. I'll try to move it for you.

thatJeffSmith-Oracle

Step by step instructions here

https://www.thatjeffsmith.com/archive/2012/08/how-to-import-from-excel-to-a-new-oracle-table-with-sql-developer/

Naveen Upadhye

Thanks all