Load Excel data sheet to Oracle database

by

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=<filename.ctl> log=<filename>.log

OR

If you just want a tool, use QuickLoad

More Related Contents:

  1. Create an Excel File (.xlsx) using PL/SQL
  2. how should I apply a formula and get answer in all the odd cells?
  3. SQL Query output in VBA is different than in SQL Oracle
  4. Sequence of numbers based on start and end value of 2 cells [closed]
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. How can I create a calendar input in VBA Excel?
  9. Using Google Chrome in Selenium VBA (Installation Steps)
  10. Ignore Duplicates and Create New List of Unique Values in Excel
  11. Merge values of column B based on common values on column A
  12. How to import a table from web page (with “div class”) to excel?
  13. Range limit conundrum
  14. Using LocationTextExtractionStrategy in itextSharp for text coordinate
  15. How do you run a .exe with parameters using vba’s shell()?
  16. Two column lookup in table array using INDEX and MATCH
  17. Concatenate cell data into another data if values matches
  18. Iterating through populated rows
  19. Does mysql have the equivalent of Oracle’s “analytic functions”?
  20. Using VBA to detect which decimal sign the computer is using
  21. Loop through each row of a range in Excel
  22. Outputting Excel rows to a series of text files
  23. How to create a range from two ranges in VBA?
  24. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  25. If string contains word from list, return value adjacent to list value
  26. excel vba freeze pane without select
  27. What can cause an Oracle ROWID to change?
  28. Converting a string representation of a constant into a constant?
  29. Oracle DB: How can I write query ignoring case?
  30. Function Overloading and UDF in Excel VBA

Leave a Comment