asp.netoracle-databaseexcelfile-uploadfilehelpers

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

Solution

  • 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.