OraFAQ Forum: Forms » Export Data from SQL Plus To MS Excel (merged)

Home » Developer & Programmer » Forms » Export Data from SQL Plus To MS Excel (merged) (Oracle 9I database and excel)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Data from SQL Plus To MS Excel (merged) [message #482363]

Thu, 11 November 2010 03:04

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

hi

i have problem with export data from SQL to excel format
my question do i can export directly data from sql to excel or i have to write sql statement in form report and from form i can export it to excel

please help

Report message to a moderator

Re: Export Data from SQL Plus To MS Excel (merged) [message #482374 is a reply to message #482363]

Thu, 11 November 2010 03:45

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

NaeemAlsaadi wrote on Thu, 11 November 2010 09:04

my question do i can export directly data from sql to excel or

If you mean sqlplus there as your topic title implies then say so. sqlplus is not the same thing as sql.

set colsep to comma(,)
and generate a csv file using spool.

Report message to a moderator

Re: Export Data from SQL Plus To MS Excel (merged) [message #482386 is a reply to message #482374]

Thu, 11 November 2010 04:05

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

thank for quick replay

i do that

but are there any way to export it from form builder to excel -
actuall i want end user to use interface to generate excel report

Report message to a moderator

Re: Export Data from SQL Plus To MS Excel (merged) [message #482669 is a reply to message #482386]

Mon, 15 November 2010 04:49

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Export what exactly?

Report message to a moderator

Re: Export Data from SQL Plus To MS Excel (merged) [message #483350 is a reply to message #482669]

Sun, 21 November 2010 01:27

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

hi
export data from my database (SQL statement) from Form Builder to excel

Report message to a moderator

Re: Export Data from SQL Plus To MS Excel (merged) [message #483354 is a reply to message #483350]

Sun, 21 November 2010 03:17

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can probably use webutil - I've never used it but if you search this forum and the web generally you should find examples. If you get stuck post back here - there are others on this site who have used it.

Report message to a moderator