Download Excel Data Sheet to Oracle Database

Question

I am looking for a free tool to load an Excel data sheet into an Oracle database. I tried the oracle sql developer, but it keeps throwing a NullPointerException. Any ideas?

Answer 1

Excel → CSV → Oracle

Save the Excel spreadsheet as a CSV file type (comma separated values).

Transfer the CSV file to the Oracle server.

Create an Oracle table using the SQL statement CREATE TABLEto determine the lengths and types of columns in the table.

Use sqlload to load the CSV file into the Oracle table. Create the sqlload control file as follows:

load data
infile theFile.csv
replace
into table theTable
fields terminated by ','
(x,y,z)

sqlload CSV , CSV . Unix:

% sqlload userid=username/password control=<filename.ctl> log=<filename>.log

, QuickLoad

Answer 2

Excel → CSV → Oracle , 9i. , . Oracle - SQL * Loader. :

http://www.orafaq.com/node/848

Answer 3

Oracle Application Express, Oracle, " " :

Utilities > Data Load/Unload > Load > Load Spreadsheet Data

CSV.

Answer 4

, Microsoft append oracle, odbc.

Answer 5

excel/csv oracle. :
1. . excel. . Tools → Import . .
2. Microsoft Access, Oracle.
1: " ", .
2: " ODBC". . .
3. Use the Oracle SQL Loader. This is a service that has a data file, a control file. You need to write a configuration. It is used as text / any file download that supports a single template.

Hope this helps. If necessary, I can share more detailed information.

Answer 6

As you mentioned, you are looking for a tool - you can check this video of a specific Oracle - you can download data from any source -

http://youtu.be/shYiN2pnPbA