Select ViewFld1 as MyLongNameField1 from ViewRemote into curosr MyTmpCursor select MyTable Append from dbf("MyTmpCursor")