Have you tried this:

rs.addnew
rs!field = chr(34) & variable & chr(34)
rs.update

>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!