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 SQL*Loader or external tables. Because we can use SQL with external tables they are generally eaiser to work with, and so are preferable to SQL*Loader 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

Jquery tabs functionality in dropdown list

jquery jquery-tabs

Ho to change the Jquery tabs content using select box

Java BorderLayout stretch east

java swing layout-manager border-layout

Is it possible to make the east (or west) side of a BorderLayout to spread over the entire panel (include north/south)?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.