Home > IT Answers > Oracle > convert query results to excel format
Nanditha
0 pts.
 convert query results to excel format
Oracle, Oracle administration, Windows
Hi, I am trying to query users with more than 4 transactions in the past quarter and bring up their address so the marketing department may send out osme mail to them. I am however told that our publishing hose wants these address in excel format. How do I convert/store the query relts into excel format.... The query pulls up some 400,000+ rows. Apprecaite your help.

Software/Hardware used:
ASKED: March 19, 2007  11:50 AM
UPDATED: March 19, 2007  12:52 PM
RELATED QUESTIONS
Answer Wiki:
There is a company called Linker IT Software that has a product call SQL*XL that links Excel to an Oracle database. It allows you to pull result sets from the database directly into Excel Here's the link: http://www.oraxcel.com/projects/sqlxl/index.htm
Last Wiki Answer Submitted:  March 19, 2007  12:28 pm  by  Dhanderson1   0 pts.
All Answer Wiki Contributors:  Dhanderson1   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can run the query directly in excel from the Data/Get External Data/New Database Query. This will utilize an ODBC connection to query your database. You can create a New Data Source from here or pre-create one from the ODBC Data Source Administrator.

Kurthp
 195 pts.