Applet Reading from Excel Sheet

[Debashish Chakrabarty]

When I am running the following as a normal java class it runs and fetches result from an excel file kept in the same directort but gives permission error. I wish to plcae the applet and excel file at geocities.com and use the excel sheet as database. Can Anyone help me with this?

import java.applet.Applet;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;
public class Example extends Applet
{
public void init() 
{
final String DRIVER_NAME ="sun.jdbc.odbc.JdbcOdbcDriver";
    final String DATABASE_URL = "jdbc :-o	 dbc :mrgreen: river={Microsoft Excel Driver (*.xls)};DBQ=Employee.xls;DriverID=22;READONLY=false";
//public static void main(String[] args)
//'throws ClassNotFoundException, SQLException
//{
Connection con = null;
try 
{
Class.forName(DRIVER_NAME);

con = DriverManager.getConnection(DATABASE_URL);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery
("select lastname, firstname, id from [Sheet1$]");
while (rs.next()) 
{
String lname = rs.getString(1);
String fname = rs.getString(2);
int id = rs.getInt(3);
System.out.println(fname + " " + lname + " id : " + id);
}
rs.close();
stmt.close();
}
catch(Exception e)
{
System.out.println("Error in init\n"+e);
}
}
}
  

If this is not the way to do can anyone guide me as to how can a text file be used as database?

[Dirk Schreckmann]

Please don't post the same question in multiple forums. It makes it difficult to follow a conversation. Let's continue this conversation in the JDBC forum...