i've forgot to mentioned that my tables are in dbase III (so .dbf files)
so you think i can do this:
.Open "hier the ConnectionStrings"
.Execute "INSERT INTO myTable SELECT * FROM otherTable"
do you think it works like this i've tried it but the otherTable is still empty.
is theres no way to use FoxPro command it will be easier if i can use such command:
APPEND FROM myTable