I tried your approach with the following code, but I'm getting a "Query expression error on the AOP5.sn line. Any idea why it's not working?

Code:

Dim mySQL_Statement As String = "UPDATE ID" & vbNewLine & _
" SET ID.NARC = AOP5.sn " & vbNewLine & _
" from IDENTIFICATION_DATA, ID, AOP5 ao where SUBSTRING (ao.NSN, 6, 11) = id.NIIN"

What is the purpose of including ID and ao in the query string? Sorry I don't quiet follow the logic.

Thanks,

Victor