No, that's wrong. It's "incorrect syntax near ','"

There is no error. The delete happens, the IF works, but the insert fails silently.

The sqlVals variable is generated from a for...each loop from a SELECT * recordset on an...

Yes, it does insert multiple values. Sorry. I should have said that.

The results of the SELECT are: insert into translators values ('Israel','Lisa','53 Dartmout Park Road','London','NW5 1SL','UK','0207 485 2874','0207 267 4469','0207...

Thanks Jeremy. You were right in your assumption and I am going to try and use dynamic sql though it looks hairy. Fingers crossed.

Sorry. that was stupid.

But now I get another error.

'Insert Error: Column name or number of supplied values does not match table definition'

The column values are supplied in an parameter. Is...