Just another one of many possible solutions..
You could use ERW to get Table data to Excel as well. I have used this method 5-10 times and it works well. Keep in mind that Excel can only accept something like 65,000 records so this may force you to consider using access.
See "Understanding Database Output" in JDE documentation under "Enterprise Report Writer." You can use database output to update the database in conjunction with your report generation. You can attach a database output specification to any report section with a business view, but not a report or page header or footer.
You can use database output to output data to OneWorld tables or to text files. Text files can be specified as either comma delimited or fixed length text records. The comma delimited format is useful for transferring data to spreadsheets.
The steps I would take are:
1) Find or make business view over desired table
2) Goto ERW, create new group section type report
3) From group report section in Report Design, goto the Section menu, then choose Database Output.
4) Complete the following fields to define a list of output tables or files (targets):
Operation,
Type = comma delimited ,
Name = c:\test.csv
5) Proceed to "Mappings", On Mappings, for each target, specify which of the available section columns or variables should be assigned (mapped) to which column in the target. Double-click on a Source Section or a Source Object cell to display a list of options.
You can also turn data dictionary overrides on and off here. On Mappings, click Map Same if you wish to map all columns.