JRower: load Oracle tables from flat files (Csv, Excel, Delimited)



JRower is a tool for loading relational database tables from flat
files. It is useful in situations where your database table undergoes
periodic refreshes from an Excel spread *** or other data file. You
supply a XML file describing the fields in the file and their mapping
to the database table columns and JRower performs the load. The data
file can be a text file in CSV, delimited, fixed length, or Excel
format. The XML file can also specify validations that the input data
must pass before it is inserted to the database. A command line tool
for running JRower is provided and also a Servlet for running JRower
from a web page. JRower can also be embedded in your own Java program.
Currently only Oracle is supported.

See: http://www.jdonohue.com/java/jrower/doc/index.html for more
information.

.