Tring to insert text to a field that is text with na apostrophe

[itm]

Hi,
The text that I am inserting go great untill I hit a name Like O'Rally then it bombs out. If I take out the apostrophe it goes great. No wI know how to wite code to go through nad rempove the apostrophes, but I was hoping that there was a way to get them in there; so the people would have the exact information.
Is there a way to do this?



Thank you
itm

[pbaldy]

I'll guess at how you're doing it and offer this tutorial:

http://www.baldyweb.com/BuildSQL.htm

[itm]

Hi,
I appreacite the link but I am not seeing how I would apply it here, but may be I am missing something. What I have is a long up date string but where it is gettting stuck is on a name field that has an apostrophe in it here is what the code looks like.
str1 = "Select * from tblTemp_Import "
rs1.Open str1, cn

rs1.MoveFirst

While Not rs1.EOF

str1 = "Update tblSAccounts Set [OwnerId] = '" & rs1![OwnerId] & "' "
cn.Execute str1

rs1.MoveNext
Wend

[itm]

I just found that if I put Val(rs1![OwnerId] )
It worked.
Thanks for you help though.
itm

[pbaldy]

The part that was relevant was that part that discussed working with fields that could have an apostrophe in them, and offereing the solution of using Chr$(34).