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?
Thanks so much in advance,
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams