The thing, i want to enter the data and thereafter export it back. So, i need
all the data entered to be exported bak in one piece.

"Pranav Vaidya" wrote:

of course you can not use Excel 2003. The quick way to get aroud is export
all this to a text file or a CSV file and then you can partly import this
file to Excel on differenet worksheets. Also you can build any pivots etc on
this text file even without transferring it to Excel.

Hope this helps!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Norma" wrote:


I want to import data into microsoft excel, from Oracle Public Sector
Budgeting. The worksheet I want to import has over 200,000 lines, yet the
excel sheet can only contain a maximum of 65,536 lines. Any body knows how
this can be done, or if its possible?


Thanks

Norma