Not too sure what you mean....

But You will see that if you connect to the AS400 with SQLCON()

handle=SQLCON()

You could then
a) Insert the data via SQLEXEC commands example:

lcsql="insert into test value('xccc')"
sqlexec(Handle,lcsql)

Otherwise more info is needed.

My point being simple construct sql statement taht pull the data from teh view and pouplate the as400 with this data.

Example

* View:
* Test
* col1 number
* col2 char

select test

go top

do while not eof()
var1=col1
var2=col2
lcsql="insert into test(col1,col2) values (?col1,?col2)"
SQLEXEC(handle,lcsql)
skip
enddo



b)
What we do is export the data from VFP into an XML document and then import it with the MQ Series application
This is because we need validaction on the fields that are inserted.
It is of course considerable work to setup.

Did you get any error messages?