• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Extract information of JD Edwards on Excel file

I want to extract some information from Accounts payable ( JD Edwards) in an Excel file is it possible
If yes how ?
please advice


I'm aware or 2 basic ways.

The first is, within oneworld, right click and export a selection from the grid
The second way, is to use ODBC, you will need database password to do this, since it does not use the jde security.
From excel, Click Data-> Import Export Data ->New Data base Query - select your odbc.

Now a few notes is you are not familiar with ODBC, then don't use it, there are some danger.

Also there are a few tools out there that might help you, try downloading OW INFO, I think the demo lets you open 1 table so you can see how it works.

hope that helps


The first is, within oneworld, right click and export a selection from the grid and select that u want to open in exell and then click ok .
Thanks for your suggestion
can you help me how i can use ODBC because i am not aware
after all that step it is asking for new query
how can i aproceed further while working in citrix