The key is that the auto inc column will not be updated. So, in the temp table, just make it type N and append, then update the auto inc column with unique values (unique to the master table).
>Thanks for the quick response, Craig. Actually the receiving table also has an autonum field (they are both basically identical tables), so I'm not sure that appending from a temp cursor would help - wouldn't I get the same message?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer