This has to be simple but I can't find a way to do it. I have a temporary table that has unedited data in it. Then I have a vb.net form that reads these records into a dataset and allows user to navigate thru these records to edit the data. When all edits are passed the user clicks a button to add these records to a permanent table in the same database.

I can not come up with a way to do this that does not throw some exception or other, usually involving the fact that the row already exists. I know it already exists! I just want to add it to another table!

Can anyone put me on the right track or do you need more info?