hi all
hi especially to those who is reading this question
i m writing a program in Java Server Pages where i want to fetch about 20,000 records from excel sheet & i hav to insert that records into access database i m developing this program for an organization where i hav to fetch this excel sheet from server will this following code work. the
following code is working for small amount of records.for large amount of records i.e for about 20,000 records it is giving me problem. plz send me a code that works for 20,000 records.plz send it urgently.i m in great tension.

code::

<%@page language="Java"%>
<%@page import="java.io.*" %>
<%@page import="java.sql.*" %>
<%@page import="java.util.*" %>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook "%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="org.apache.poi.poifs.filesystem.POIFSFileS ystem"%>
<%@page contentType="application/vnd.ms-excel" %>

<%
HSSFRow row;
HSSFCell cell;
Connection con=null;
PreparedStatement stmt;
String parea="",esgrp="",egroup="",personelsub="",halfnam e="",esubgroup="",costctr="",psubarea="",designati on="",position="",name="";
int bc=0,tno=0,eegrp=0,flag=0;
String name1="";
String arr[]=new String[14];
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:deploym ent","","");

}
catch(Exception e)
{
out.println(e.getMessage());
}

try
{
name1=request.getParameter("file");
out.println("Path="+name1);

POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(name1));

HSSFWorkbook wb=new HSSFWorkbook(fs);

HSSFSheet sheet = wb.getSheetAt(0);

int rows;
rows = sheet.getPhysicalNumberOfRows();
out.println("Rows are"+rows);

int cols = 0;
int tmp = 0;

for(int i = 0;i < rows; i++)
{
row = sheet.getRow(i);
if(row != null)
{
tmp = sheet.getRow(i).getPhysicalNumberOfCells();

if(tmp > cols)
cols = tmp;

}
}
out.println("Columns are="+cols);
int m=0;
for(int r = 0; r < rows; r++)
{
row = sheet.getRow(r);
if(row != null)
{
for(int c = 0; c < 15; c++)
{
m=c;
out.println("<br>");
cell = row.getCell((short)c);
if(cell != null)
{
if(m==1||m==5||m==9)
{
arr[c]=Double.toString(cell.getNumericCellValue());
}
else
{
arr[c]=cell.getStringCellValue();
out.println("Arrayvalues=="+arr[c]);
}

}//if
else
{
if(m==11)
{
arr[c]="";
}
}

}//for


}//if
}//for




}
catch(Exception e)
{
%>
<script language="JavaScript">
alert("Error while inserting");
</script>

<%
out.println(e.getMessage());
}

%>

in this program i m just fetching the values from excel sheet & it is giving problem for 20,000 records.
plz send it urgently
thanks in advance