INSERT Statement with a quote (') in the Data

[WoodyRoundUp]

Hi guys.
I have a question.
I am using VB to write a program, where I will be using an SQL Statement to Insert Data into Table.
But, in the my SQL String, there are fields with a single quote (for example: Jack's)
But the Access Jet Engine will read it differently. and error happens.
Is there any way solve?

Anyway my sql string looks like this:
SQLStr = "INSERT INTO myTable VALUES ('" + myVariable.Text + "')"

while in the myVariable.Text = "Jack's"

the error is from the myVariable.Text.

Please help.
Thanks.

 

[chiph]

If you use ADO parameters this is taken care of for you.

Chip H.