SQL tutorial 44: How to import data from Microsoft Excel to Oracle Database using SQL Developer

Step by Step Oracle Database/ SQL tutorial on How to import Data from Microsoft excel to the oracle database using SQL Developer.

Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄

Create Table using
●SQL Developer & Command Prompt:
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage

--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at

Connect with me on my LinkedIn and Endorse My Skills and Do you know that I share Tips and tricks On Google+ Account?

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[JunaidKhan-gqnw]

Sir, Genius you are. What a fantastic way to explain. Thanks.

[rameshthamizhselvan]

I have seen so many videos in the youtube but your video is crystal clear. such a nice man your.

[HimaliParikhnra]

i have recently subscribed to ur videos and i must say all ur videos are really helpful as they are with simple instructions and easy to follow and i can understand it very well..thanks alot...

[youssefbatate]

thank you Manish, i will have this course in college next spring semester. I am preparing to know as much as I can to do well for that class.
I have some questions but I'm trying to figure it out by myself so far.!!

[hylee]

Very clear and concise instructions and explanations. Thank you, Manish!

[shyamalmukherjee]

Thank you Manish, very crisp and clear

[vichetkim]

That's awesome. Thankyou. Is there a possibility you could please show me how to import tables from MS-ACCESS?

[akkugamer]

Very helpful Video Manish... Good Keep it up Thanks Manish

[sachinshirke]

Good work Manish...

Keep it up..

Cheers !!!

[JeffSmiththat]

Another great video, I can see why you have so many subscribers :) 

You can skip the step of creating the table first, if you do an import from the main table node, it will create the table based on the Excel file, and then do the import.

Also, look for some enhancements in this feature in version 4.1 that will make this wizard much easier to work with!

[arsenruslanovich]

good work, your course helps me a lot

[mohan]

Good Work & Thank you for your efforts.

[roopadevibp]

Manish, if we have constraints in tables & if there any dependency among tables, then how can we import the csv files. Thanks in advance..

[tarisaimunodawafa]

This guy is pretty awesome. Thanks bro

[ridhisinha]

VERY well explained thank you for teaching us. If you can make video or tell me in a easy way about these Error when i am trying to load company data which has 7000 records "SQL*Loader with multiple WHENs is rejecting all rows " and Trailing Nullcols is occurred how to resolve this problem .Thanks In advance.

[devanshu_]

Thank you Manish.. How can we import multiple excel sheets/Tabs at the same time ?

[ajazqudrat]

Why we define data columns in DB again as they are already defined in Excel

[swetavarshney]

is there any way do it without change in ordering of data?? i getting data in table in diffrent order that that in excel file .

[marlojustaga]

can you load excel data into cursor using oracle procedure or pl/sql block? I don't want to create new table as data from excel file is used to update existing table in oracle database.

[KhanReyad]

Hello Manish Brother ! I'm from Bangladesh. I always watch your tutorial and learn much more.I have to create an Apex application where I want only brows Excel Sheet and Insert data Pressing load data Button only. No click anywhere more. Please help me Brother..