Hello everyone,

I have many small tables with different names but identical structure, my task is to extract some data from each of them and append into a cursor. The only way I can do this is to save the data from small tables into an array, then put them into the cursor, but I feel this not the best way, I want to transfer the data directly but not through the array.

The way I want to do is:

Create Cursor MyCursor
FileList=adir(SmallTable_xx.dbf)

For each SmallTable in FileList
  Extract useful data from SmallTable
  Insert the data into the Cursor &&such that no need to sort afterward
Endfor

Is it possible to open 2 tables at the same time, then put the data from one to another? If yes, would someone please teach me how? Or any other suggestions?

Thanks in advance!!