>Edward- do you mean to create a cursor, and then append from the SQL >cursor? If so, is there a way around having to name and define each field? >(table has about 80 fields). I was thinking that I could select into an >array and then 'CREATE CURSOR cmytemptable FROM ARRAY cmyarray', but was >having problems gettting that to work. The easiest way to do it: OriginalFile_lc=dbf() =afields(flds_la) Create Cursor newcurs From Array flds_la append from (OriginalFile_lc) It works no matter if the original alias was a table, cursor, view or whatever.