I agree with the INSERT INTO rows SELECT rows FROM table but if the common column in the receiving table is autonumbered, you might need to take AUTONUM off that column temporarily. I'd assume you are appending rows from some working table into some backup or archival table?
On Fri, Jan 13, 2012 at 6:45 AM, Castanaro, Bob <[email protected]>wrote: > there -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
