i using as/400 reflections ibm. here question: how can data excel sheet transfered as/400 session. there should ble create macros add info ever needs inserted. depends on requirements, multiple methods available, transport, ftp saved as400 odbc excel iseries save file in ifs (e.g. /home/data). brings sheet in scope of as400 start client access emulator (tn5250), , use transport in program. can use external file describes format start client access file transfer, , use external file descriptions format, save flat file, , use cpyf (*map, *drop) db2 table as flat file db2 table 1 field (e.g. crtpf). table can processed iseries program, query/400 or sql save csv , use command "copy import file (cpyfrmimpf)" or "copy stream file (not sure top of head, cpyfrmstrf) save csv , use descriptor file import db2 table setup, directly excel (e.g. odbc) with file transfer (e.g. save in excel, ftp, cpyfrmimpf) script (e.g. use com functions in perl...