Discussion Locked

Excel 2003 downloading to AS400

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I was wondering if anyone knew why you cant download from AS400 (mainframe) in MS Excel 2003, but you can in MS Excel 2000. On the 'Data' tab it list the options, but for some reason you cant download from AS400. Only import external data from the web etc.

Thanks for your help

3 replies

by ori1028

Hello there,
This is Javier Cuellar, use CPYTOIMPF command. This command allows you to transfer a physical file in to a PCASCII file. The command actually converts the file into a CSV that you can easily pull from Excel. You need to have access to the IFS system from the AS400. Use Client Access and use File Systems to map the folder where you need to copy your file. ori1028@msn.com if you need extra help.

This discussion is closed to new replies.