I am reading the contents of a text file into VB variables. Some of the text contain two single quotes in succession ''. I need to replace the two '' with one " and then insert into a recordset. I am not using the insert statement I am using:

rs.addnew
rs!field = variable
rs.update

How do I go about this?

Thanks!