Coming in late on this thread, but ...
How about ALTER TABLE and RENAME COLUMN (to 'xxxx') right before the append, and the rename the column back right afterwards?
Just a thought ...
>>>I am trying to append data from various files of varioius formats. for now: dbf, txt, cvs and txt.
>>
>>Just curious...whats a cvs file?
>
>er CSV - one of the COPY TO / APPEND FROM formats
>
>>
>>>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
>>
>>Try APPEND FROM (LCFILNAM) FIELDS EXCEPT PKAD
>>
>
>I get error #10 "Syntax error." Can you give an example?
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".