Load Excel data sheet to Oracle database

Question

I am looking for a free tool to load Excel data sheet into an Oracle database. I tried the Oracle SQL developer, but it keeps throwing a NullPointerException. Any ideas? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Excel -> CSV -> Oracle Save the Excel spreadsheet as file type 'CSV' (Comma-Separated Values). Transfer the .csv file to the Oracle server. Create the Oracle table, using the SQL CREATE TABLE statement to define the table's column lengths and types. Use sqlload to load the .csv file into the Oracle table. Create a sqlload control file like this: load data infile theFile.csv replace into table theTable fields terminated by ',' (x,y,z) Invoke sqlload to read the .csv file into the new table, creating one row in the table for each line in the .csv file. This is done as a Unix command: % sqlload userid=username/password control= log=.log OR If you just want a tool, use QuickLoad