convert query results to excel format

pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kurthp
    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.
    195 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following