Wahyu:
To connect to AS400, Use your ODBC conection in My computer then in VFP use SQLconnect and View or SQLexec to extract the data. Nothing difficult. You have a lot way in VFP to do that. BTW, the SQL statement should be writen in AS400 syntax. No all regular SQL Syntax are well understood by AS400. So be prepare for the syntax error surprise!!.