hi,
     I am using some simple string fields in a simple Access
database table. Sometimes I have apostrophes in the text data eg
in a name field I may have John O'Hara. If I build my insert
query this apostrophe causes me a problem eg
 "insert into mytable (name) values ('John O'Hara')"

the apostrophe in the O'Hara signals the end of the string and
my sql code fails. How can I overcome this ? Is there a way that
I can keep the original text in the data or do I have to substitute
the apostrophe character for something else like "`" ?

Cheers muchly.

You have must replace that string before run query insert.
For example: value ="Lam's"
value=replace(value,"'","""")
then make query and run it !. Right !?



L.V.L