I'm am running a process that captures all the text files in a directory. Next, I'm attempting to append from those captured text files into their own separate table. For example,

sele temptble
appen from arrayname fields a, d, e, f delimited
ren temptble to substr(arraryname,1,8)

Then I re-create the table and do it all over again. Until the last file is appended.

The problem is that it's not capturing and appending from the array?

Cany anyone help with this matter?

APPEN FROM (AIMPFILES(I,1))FIELDS CDC_ID, SPECNO, INCDATE, INPROCDATE DELIMITED

SELE TMPTABLE
USE

RENAME TMPTABLE.DBF TO SUBSTR(m.tmpfname,1,8) + '.DBF'

TIA

Jeff T.