A simple mode to read from csv files is shown heare:
http://www.csvreader.com/java_csv_samples.php

I hope it will help you !
Antonio

Have you considered using an ODBC driver and using that to access Excel
or a CSV? Using the JDBC-ODBC bridge it shouldn't be too difficult
(bearing in mind that Sun's JDBC-ODBC bridge isn't considered suitable
for heavy production use). There's details of how to use it here:
http://www.techbookreport.com/tutorials/jdbcodbc.html

HTH

On Wed, 20 Jun 2007 07:42:19 -0700, "delcas2004@gmail.com"
<delcas2004@gmail.com> wrote, quoted or indirectly quoted someone who
said :

see http://mindprod.com/jgloss/csv.html
for various options to read your CSV files.  Then you have the
standard problem of putting them into your database.

Often a database has a batch feature for rapid import of data that
turns off some of the journalling.  Usually it accepts CSV or some
variant you can fairly easily translate to.

For example, MySQL has the mysqlImport utility.
--
Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

you may want to see OpenXML4J at : http://www.openxml4j.org/

OpenXML4J is a Java library dedicated to the creation and manipulation
of Office Open XML (ECMA-376) and OPC based documents (for example
Office 2007 Word, Excel and PowerPoint documents). OpenXML4J provides
you a way to create and manipulate Open XML documents for a bunch of
scenarios without using any office suite.

On Jun 20, 10:42 am, "delcas2...@gmail.com" <delcas2...@gmail.com>
wrote:

Fer,

You can also try my company's Data Pipeline product:  http://northconcepts.com/

Here's an example from our cookbook:

-- code snippet ---------------------------------------------

package com.northconcepts.datapipeline.examples.cookbook;

import java.io.File;
import java.sql.Connection;
import java.sql.Driver;
import java.util.Properties;

import com.northconcepts.datapipeline.core.DataReader;
import com.northconcepts.datapipeline.core.DataWriter;
import com.northconcepts.datapipeline.core.Job;
import com.northconcepts.datapipeline.csv.CSVReader;
import com.northconcepts.datapipeline.jdbc.JdbcWriter;

public class WriteACsvFileToDatabase1 {

   public static void main(String[] args) throws Throwable {
       // connect to the database
       Driver driver = (Driver)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
       Properties properties = new Properties();
       properties.put("user", "scott");
       properties.put("password", "tiger");
       Connection connection = driver.connect("jdbc:odbc:dp-
cookbook", properties);

       DataReader reader = new CSVReader(new File("credit-
balance.csv"))
           .setFieldNamesInFirstRow(true);

       DataWriter writer = new  JdbcWriter(connection,
"dp_credit_balance")
           .setCloseConnectionOnClose(true);

       Job.runNow(reader, writer);
   }

}

-- code snippet ---------------------------------------------

You can download the cookbook & software from
http://northconcepts.com/products/data-pipeline/downloads.html

If you have any questions, feel free to post it here or in our fourms.

Good luck,
Dele