Earlier today I was very grateful when you all helped me with my problem. The code worked great with one exception. It only appended the first file. What I am trying to accomplish is appending for instance 25 different text files delimited with the same structure to one table. It takes only the first text file, appends it perfectly, but then stops. Do I need to write a loop. Any help would be appreciated the code is below.

lparameters tcPath
local lnFiles, ix
m.lnFiles = adir(aTextFiles, m.tcPath+'*.txt')
for m.ix = 1 to m.lnFiles
wait window nowait 'Appending : '+m.tcPath+aTextFiles[m.ix,1]
append from (m.tcPath+aTextFiles[m.ix,1]) delimited with character :
endfor
wait clear

At this point I chose the table and ran the program. However as I said only the first file appended.


Thank you.

Sincerely,


Phil Haak
Foxpro - Neophyte