You could adapt the code for importing files with more than 64K lines
described on and dowloadable from
http://www.cpearson.com/excel/ImportBigFiles.htm . The code is written for
text and CSV files, but should easily adaptable to any type of data source.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Vikram Dhemare" wrote in message
...
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