Home » SQL & PL/SQL » SQL & PL/SQL » Export data to an excel file
Export data to an excel file [message #187309] Fri, 11 August 2006 15:30 Go to next message
developer2006
Messages: 3
Registered: January 2006
Junior Member
Hi Guys,
I was able to export data to an excel file witout any problem. But in the excel file some rows are broken into two lines. Is there any line size restriction in excel? How can I specify that in my pl/sql code. I used v_file_id := ('dir_name','filename.xls','w',32000);

Any suggestions?
Thank you in advance.
Re: Export data to an excel file [message #187431 is a reply to message #187309] Mon, 14 August 2006 00:26 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See solution provided here - http://www.orafaq.com/faq/how_does_one_load_ms_excel_data_into_oracle
Re: Export data to an excel file [message #187749 is a reply to message #187431] Tue, 15 August 2006 06:49 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
No of chars per cell in Excel 32767
Previous Topic: ORDER BY - special edition.....
Next Topic: Help Needed on Conditional Select Statement (CASE?)
Goto Forum:
  


Current Time: Wed Dec 07 04:59:23 CST 2016

Total time taken to generate the page: 0.11578 seconds