Exporting data from report 6i to excel

15 pts.
Tags:
Microsoft Excel
Oracle 6i
Oracle 6i import/export
Can anyone tell me how to export data from report 61 to excel? I am looking for the code to do this.

Answer Wiki

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

One way to create a CSV file that can be opened with Excel would be setting this parameters when calling the report, to generate its output to a delimited file

MODE= Character
DESTYPE= File
DESFORMAT= Delimited
DESNAME= 'YourFile.csv '
DELIMITER= ','

You could also use some third party tool to make the export.

And other option would be to create the excel file from Forms. How to do this has been asked before. Here’s a question about this:

How to call Microsoft Excel from Oracle Reports/Forms 6i

———-

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
  • Craig Hatmaker
    This is more generic than what you are asking for but you may find it useful just the same: Beyond Excel
    1,745 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