>Anyone have an idea how I can open files from a directory and append them to a table programatically? Filenames are unknown at run-time.
>
>TIA.

Do the files have the same structure?

Try

on error ReportError(error(), message())

use myMainTable in 0 alias MainTable
lnFiles = adir(laFiles, m.lcMyDir + '*.dbf') && assuming we're working with DBFs
for lnI = 1 to m.lnFiles
    use (m.lcMyDir + laFiles[m.lnI,1]) in 0 alias WorkFile
    select MainTable
    append from dbf('WorkFile')
    use in select('WorkFile')
next

Add an error routine.