problem with single quote in recordset field of UPDATE query 1

[rss0213]

I have this code to update an Access table from a text file (this is actually vb script):

sqlStr = "UPDATE CustomersMain SET [RMName] = '" & trim(oRS("OfficerName")) & "' WHERE [CustomerID] = " & trim(oRS("CustomerId"))

Problem I have is when an OfficerName has a single quote in it, like O'BRIEN. how do I handle this?

Thanks!
Scott

 

[Andrzejek]

Try:

sqlStr = "UPDATE CustomersMain SET [RMName] = '" & [blue]Replace[/blue](trim(oRS("OfficerName"))[blue], "'", "''")[/blue] & "' WHERE [CustomerID] = " &  trim(oRS("CustomerId"))

Have fun.

---- Andy

 

[rss0213]

That did it!

Thanks!
Scott