Simple – AS/400 creates a comma delimited file on one of the “IFS” folders
You pull it from there into ACCESS.
Another option would be to configure an ODBC/OLEDB driver to your AS400 for your Access database. If you have real time access to your client’s AS400, this will give you realtime access to that data (allowing you to view the table(s) on the AS400 as linked tables in Access). There may be security implications for your particular implementation, but it’s worth discussing with the AS400 administrator. It sounds more complicated than it is; it takes about 5 minutes to set up the connection and link the tables, from there they’re just like Access tables… the advantage is once it’s connected you don’t need to “transfer” anything – it’s just there in your database whenever you connect/log in.