Filehelpers Excel to Oracle db

I want to import excel data to oracle DB. I got enough help for Excel part, can you guys help me in Oracle side?

Is it possible to import to oracledb with filehelpers? Please provide some sample code for reference.

Thanks Dee

Answers


If you save the spreadsheet data as .csv files it is relatively straightforward to import it into Oracle using SQLLoader or external tables. Because we can use SQL with external tables they are generally eaiser to work with, and so are preferable to SQLLoader in almost all cases. SQL*Loader is the betterchoice when dealing with huuuuge amounts of data and when ultra-fast loading is paramount.

Find out more about external tables here. You'll find the equivalent reference for SQL*Loader here.


Need Your Help

Node.js 5.5.0 console.log won't log

javascript node.js terminal console.log

I can't get any terminal output when I call console.log("anything") anywhere in my app. The issue seems to have started when I updated node to 5.5.0, before that I had no issues. What's going on? I...

RSpec view specs - Check that layout yields

ruby-on-rails ruby rspec rspec-rails

I want to check that my layout yields (either with no args or for specific content):