>My problem is I have hundreds of files to append, and all that changes is the

so you are issuing 'append from blah blah blah' hundreds of times?

if so; but all your text files into the same directory.

use MyTable
cd ImportDir
lnTotalFiles = adir(laFileNames, '*.txt')

for x = 1 to lnTotalFiles
appe from &laFileNames(x,1) deli with char :
endfor