Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I add the Data Transfer from AS400 option to Excel?

April 26, 2017AS400 Data Excel option transfer

0

Posted

How do I add the Data Transfer from AS400 option to Excel?

1 Answer

0

Posted

http://faq.midrange.com/data/cache/194.html Another is to use CPYTOIMPF and/or CPYTOSTMF, or for the other way, CPYFRMIMPF and/or CPYFRMSTMF. These will transfer data from DB2 into the IFS. Quite easy to make a CSV file to port between Excel. There are issues that some people have with it, especially after V5R3, so many have started reading and writing to the IFS directly.