>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