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...