How to Import a CSV or Excel File in SQL Developer

[@academyninjakids9247]

I am not able to find a right directory to my path. It's looks like local file doesn't include my local disk. Do you know how to fix that?

[@DatabaseStar]

Hmm I'm not sure actually. Do you see your computer and its folders when you browse for the file?

[@patrick2288]

It works on smaller CSV files, but fails for CSV files with over 250,000 tuples. Any clues to why?

[@DatabaseStar]

Hmm I’m not sure. What issue or error message are you getting? Or does the app just freeze?

[@patrick2288]

@@DatabaseStar I fixed it, apparantly I had an incorrect table foreign key and was forgetting the COMMIT; line at the end of the file. Thank you for the concern on this comment for a 2 year old video :)

[@DatabaseStar]

Glad you got it resolved!

[@shruthi9393]

He is good and it works

[@DatabaseStar]

Thanks!

[@amanahmed6057]

this connection section is not coming to in interface
what should I do?

[@DatabaseStar]

Could you try restart SQL Developer to see if it appears?

[@angelbear_og]

Thank you!

[@DatabaseStar]

You're welcome!

[@Rhg2204]

how to do it on mac?

[@DatabaseStar]

It should be the same process on a Mac.

[@asafezrati]

Makes me feel sleepy

[@DatabaseStar]

Importing a CSV makes you feel sleepy?