Hi Carl,

>>>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?

Sorry bout that. Forgot the APPEND FROM command doesnt except the LIKE/EXCEPT clause. :-(

(From Ed Rauh's post)

export the structure of the table either to an array (using AFIELDS) or COPY STRUCTURE EXTENDED, remove the PKAD entry (using AFIELDS, do an ADEL and redimension the array, or COPY STRUCTURE EXTENDED, delete the data row defining PKAD from the strucxture file) and create an intermediary file based on the revised definition which would be used to import the data. You would then add the data from the intermediary file to add imported record

I would implement something along these lines.

Sorry again about the mix up.

Jon