export data from forms to excel
Home > IT Answers > Development > export data from forms to excel
Brithivi
5 pts.
0
Q:
export data from forms to excel
SQL, PL/SQL
how to export the selected data from forms to excel?..
ASKED: Jul 30 2009  6:55 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Jjohannsen
285 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Create a view with the filter conditions. Then export the data using export command.

--------- jjohannsen

I know of a product that installs as a storedproc in the database that can take a cursor or SQL select statement and deliver a CLOB back in an XML file format that opens natively in MS Excel. I am using it on a project right now, and our users are loving it.

www.peak42solutions.com
Last Answered: Oct 9 2009  4:02 PM GMT by Jjohannsen   285 pts.
Latest Contributors: Mraman   260 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29750 pts.  |   Jul 30 2009  1:41PM GMT

What version of forms are you using ?
The answer could be completely different depending on that.

 

Carlosdl   29750 pts.  |   Sep 4 2009  1:38PM GMT

The export utility won’t export the data in excel format. The file generated with EXPORT can only be used to import with the IMPORT utility.

 
0