Note that the following will NOT work:

append from la_tables(i)
* or:
append from some_variable

This is because Visual FoxPro looks for a file named some_variable, or la_tables(i).

You have to force Visual FoxPro to evaluate the variable (or expression), with the extra parentheses.

>thank you,it works
>
>>At the end, you just need to change the expression for the array element.
>>
>>

>>...
>>for i = 1 to 47
>>  append from (la_tables(i))
>>next
>>

>>
>>Otherwise, it looks as if it should work.
>>
>>>hi all,
>>>
>>>i need help to append all tables as below to one table,
>>>
>>>thanks
>>>
>>>

>>>DIMENSION la_tables(17)
>>>la_tables[1] = "t1"
>>>la_tables[2] = "t2"
>>>la_tables[3] = "t3"
>>>la_tables[4] = "t4"
>>>la_tables[5] = "t5"
>>>la_tables[6] = "t6"
>>>
>>>la_tables[7] = "t7"
>>>la_tables[8] = "t8"
>>>la_tables[9] = "t9"
>>>la_tables[10] = "t10"
>>>la_tables[11] = "t13"
>>>la_tables[12] = "t16"
>>>
>>>la_tables[13] = "t19"
>>>la_tables[14] = "t40"
>>>la_tables[15] = "t41"
>>>la_tables[16] = "t42"
>>>la_tables[17] = "t43"
>>>******************************************
>>>
>>>copy structure to combined2008
>>>use combined2008
>>>
>>>for i=1 to ....
>>> 
>>>APPEND FROM (lc_txtfile)
>>> 
>>>next
>>>