if i have a value that has to be insterted into a field in Access but the value has a single quote, ie. Example's. if i write the instert statement the following way would it work?


VB Code:
  1. dim sql as string = "insert into THETABLE (THEFIELD) values(" & """example's""" & ")"