Geek Answers Handbook

Filehelpers Excel in Oracle db

I want to import excel data into Oracle. I got enough help for the Excel part, can you guys help me on the Oracle side?

Is it possible to import into oracledb using filehelpers ? Please provide sample code for reference.

Thanks Dee

+1
source share
3 answers

If you save the table data as CSV files, it is relatively easy to import them into Oracle using SQLLoader or external tables. Since we can use SQL with external tables, they usually work with eaiser, and therefore, SQLLoader is preferred over almost all cases. SQL * Loader is the best choice when working with huuuuge data and with ultra-fast loading.

Learn more about external tables here . You will find the equivalent link for SQL * Loader here .

+2
source

A simple and relatively stupid way to do this for one-time tasks is to create a new column in an excel sheet containing this formula:

="insert into foobar values('"&A1&"','"&A2&"');"

Copy this to all rows, then copy the entire column to the editor and run it in SQL * Plus or sql developer.

+1
source

I use Sqlloader to load data from CSV to Oracle DB.

0
source

More articles:


All Articles