>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?
Seems to me the easiest thing to do would be to drop your Primary key constraint while uploading the files, and go back through the appended data and add the primary key when the process is complete.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown