Home » Infrastructure » Windows » import the data either in excel or csv file more than 65000 records (oracle 10g)
import the data either in excel or csv file more than 65000 records [message #434361] Tue, 08 December 2009 23:29 Go to next message
chaituu
Messages: 115
Registered: June 2008
Senior Member
i want import the oracle data into either in excel or csv file.if it is below 65000 records then using PL/SQL developer editor then i can copy into excel file.but it is more than 65000 records then not able to import the data into excel. in excel per sheet we can accomidate only 65536 records.i have more than 1 lakh records then 2 sheets should come in one excel file.
Re: import the data either in excel or csv file more than 65000 records [message #434363 is a reply to message #434361] Tue, 08 December 2009 23:36 Go to previous message
BlackSwan
Messages: 21955
Registered: January 2009
Senior Member
This is NOT an Oracle problem.

upgrade to a current/newer version of Excel that does not have this limitation.

This topic/thread is locked.

[Updated on: Tue, 08 December 2009 23:36]

Report message to a moderator

Previous Topic: Rename Files with more than one dot in the name
Next Topic: Oracle XE + Dev6i on Windows 7 , is it possible?
Goto Forum:
  


Current Time: Sun Apr 20 22:49:20 CDT 2014

Total time taken to generate the page: 0.08328 seconds