How to Read Excel file??

[spalax]

Hi,
i'm new in java prg
i'm trying to write a code for extracting data from an excel file.

The excel file name is : TEST.XLS
The worksheet name is: qas
In the Tool Administrator, the datasource name is: qa-list

When i excecute the code, i have an error:

java.sql.SQLException: [Microsoft][Pilote ODBC Excel] Not enough parameters 1 waited.



here is my code:

package javaexcel;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class ExcelReader
{
    public static void main( String [] args )
    {
        Connection c = null;
        Statement stmnt = null;
        try
        {
            Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
            c = DriverManager.getConnection( "jdbc:odbc:qa-list", "", "" );
            stmnt = c.createStatement();
            String query = "select URL from [qas$]where Archive=5;";
            ResultSet rs = stmnt.executeQuery( query );

            System.out.println( "Found the following URLs for March 2000:" );
            while( rs.next() )
            {
                System.out.println( rs.getString( "URL" ) );
            }
        }
        catch( Exception e )
        {
            System.err.println( e );
        }
        finally
        {
            try
            {
                stmnt.close();
                c.close();
            }
            catch( Exception e )
            {
                System.err.println( e );
            }
        }
    }
}

[PhHein]

Why don't you use POI or JExcel?

[spalax]

Problem solved.
thanks

[Eranga]

Please mark the thread solved, from thread tools menu, if you've found the solution for your question.