Extract information of JD Edwards on Excel file

vineet mukhi

Member
I want to extract some information from Accounts payable ( JD Edwards) in an Excel file is it possible
If yes how ?
please advice
regards
 
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
Jane
 
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
 
To export to Excel from OneWorld in a Citrix session, you need Excel (office) installed on the Citrix server.
 
Back
Top