View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vikram Dhemare Vikram Dhemare is offline
external usenet poster
 
Posts: 44
Default Import Oracle Dbase over 65k rows

Hi,

Everyday I used to import the oracle database (Sales Data - Invoice
Numberwise) in Excel.
Now the data is almost about 1,50,000 rows and excel have a limitations of
65000 rows.
Is there any solution, say if the recordset data is above 65000 rows then
excel should
add another sheet & copy the data upto 65000 rows in one sheet & above 65000
is in
another sheet.

Help in this regard will be hieghly appreciated.



--
Thanks,
Vikram P. Dhemare