Hi Friend,

Try the following:

<%@page import="java.sql.*"%>
<%
Connection conn=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:access");
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from data");
while(rs.next()){
out.println(rs.getString(1)+" "+rs.getString(2)+"<br>");
}
rs.close();
st.close();
Statement st1=conn.createStatement();
ResultSet rst=st1.executeQuery("Select * from Employee");
while(rst.next()){
out.println(rst.getString(2)+" "+rst.getString(3)+"<br>");
}
rst.close();
st1.close();
conn.close();
}
catch(Exception e){}
%>

For more information, visit the following link:

http://www.roseindia.net/jdbc/Jdbc-odbc-connection.shtml

Thanks