View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default Importing Data Into Excel

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