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

try

rs!field = Replace(variable, "''", Chr(34))