I am trying to append data from various files of varioius formats. for now: dbf, txt, cvs and txt.

I want to block my primary key field from the fields being appended. I have a default set for it, and that is what I want to assign pk's. the rest of the fields (name, addr...) I want to append from.

If the source is dbf, I don't know what fields will and won't be there, so I can't just list out all the fields in the destination table (less the pk), because they may not exist in the source.

I have tried using
SET FIELDS TO ALL EXCEPT PKAD

but the APPEND FROM command seams to ignore it.

APPEND FROM (LCFILNAM) FIELDS ALL EXCEPT PKAD

is a syntax error.

anyone got any interesting ideas?