Excel Data Population using Java

What is the best and efficient way to read and populate the data in to oracle database....

Large number of sheets' data should be trasfered to the oracle database
using the j2EE technologies

"hareesh" -

Welcome to the JavaRanch! Please adjust your displayed name to meet the
JavaRanch Naming Policy. User names cannot be obviously fake and must constist of a first name and a last name.

You can change your user name here.

Also, I think that you need to describe your problem in a little more detail... are you looking for information on EJBs vs. other technologies? And also a description of what "sheets' data" means... data from web forms?

Thanks! and welcome to the JavaRanch!

I want to use j2ee framework for uploading the data in EXCEL (.XLS) sheets to the orcle database.

Suggest me the best solution which is good at performance and accuracy

A Google search on Excel Java brought up these two products.
There is nothing native in J2EE for working with Excel.

http://officewriter.softartisans.com/OfficeWriter-306.aspx
http://jakarta.apache.org/poi/

You can read Excel files through JDBC
(e.g. via JDBC-ODBC bridge - it is free)

According to Sun, the jdbc-odbc bridge is not suitable for production apps:
http://java.sun.com/products/jdbc/faq.html#20

The Bridge is a normal ODBC client. Note, however, that you should use the JDBC-ODBC Bridge only for experimental prototyping or when you have no other driver available.

>According to Sun, the jdbc-odbc bridge is not suitable for production
>apps:

And according your own experience? ;-)

Actually all the problems belong to the concurrent access/scalability. If you need to move once data from Excel to Db � it is probably Ok, there in no concurrency

Originally posted by Dan Novik:

And according your own experience? ;-)

I've used it without incident, but not in a production environment.

thank for giving me suggestions

but I am using JXL package

do u have any idea about its capabilities