>>Using the basic ADODB construct how would I do an append from another table? I am trying to avoid a large loop for each record with a loop for each field. Alternatly if I could add a whole row at a time that would be very cool.
>>
>> The meat is this: I have a smaller table that needs to be appended to a master table. What would be my best bet?
>
>If both tables have the same structure, use this:
>insert into sysentity
>SELECT *
>FROM ZZsysEntity
>
>If tables structure are not the same, then you can use this:
>insert into sysentity(F1, F2, F3)
>SELECT (F4, F5, F6)
>FROM ZZsysEntity

Thanks. It looks a little like three unrelated commands to the fox user in me, but, the C++ programmer says if it works roll with it. :} Again, my thanks.