>>I need to append from a table only those records I have not appended before. I have a unique field but just cannot find the proper way to do this.
>>I have to append data from 3 remote locations into a local table daily
>>without duplicating these records
>>any ideas?
>>thanks in advance..
>>Dave Carter
>
>You can use a SQL select to get the records you haven't previously appended and then append them from your temporary cursor.
>
select * from mytable where mytable.uniqueID not in ;
> (select uniqueID from targettable) into cursor c_temp
>select targettable
>append from dbf("c_temp")
>
>HTH.
Man....when I think of the things I don't see...
Thanks I believe that will do it.
Dave Carter