I have a table that exists in my library in as400 and has 1000 records. I want to copy data from the table in as400 to Excel. Please let me know how to copy data from the as400 table to Excel.
Sorry, you do not have permission to ask a question, You must login to ask a question.
Sorry, you do not have permission to ask a question.
You can copy the data from as400 to Excel by using the data transfer utility by following some steps if you have
Access Client Solution
(ACS) installed at your end.ACS
and then from the General menu open the Data Transfer utility.Data transfer utility
opens up, then select From IBM i tab to export data from as400 to Excel.library/filename
that you want to export from the as400 system.output device
as File under the file section.details button
and the File details dialog opens..xlsx
)..fdfx
type file i.e. file description files, and now provide a file name and click on open that will close the dialog box.user ID
andpassword
and after that, the data will be copied from as400 to Excel.