Inserting ' into table from vb to access. (Urgent)
Posted on 2004-03-27
i am trying to insert a ' from a visual basci query into a table in access but getting systax error becase while building query v use ' as text container like in follwoing line.
plz help me out.
insert into tblStudent values( 1, 'Sachin's wife'); //error
insert into tblStudent values( 1, 'Sachin s wife'); //no error
is there any way to solve this problem easy & reliable.
plz help with some gud example of quotation
must be simple if u have more than one solutions plz welcome