santosh_tamse
02-28-2009, 04:30 AM
hi all
i m writing a program in which i hav to read 20,000 thousand records from excel file.
i hav written that code but it works fine upto 15,500 & after that it gives problem it gives out of memory error.
so i hav thought to break one excdel sheet that contains 20,000 records into 2 excel sheet that will each contain 10,000 records each of previous excel file that contains 20,000 records each.
so plz can u tell me how to break one excel sheet into 2 excel sheet
plz send me reponse as fast as possible
i m writing a program in which i hav to read 20,000 thousand records from excel file.
i hav written that code but it works fine upto 15,500 & after that it gives problem it gives out of memory error.
so i hav thought to break one excdel sheet that contains 20,000 records into 2 excel sheet that will each contain 10,000 records each of previous excel file that contains 20,000 records each.
so plz can u tell me how to break one excel sheet into 2 excel sheet
plz send me reponse as fast as possible