String value contains quote

[Fae]

In Access 2000 using VBA

I have a string value e.g.
500mg Litchi "A" duplex box (string value uses double quotes) or
or 500mg Litchi 'A' duplex box (string value uses single quote)

How do I insert that record (which can be either the one or the other - indicated above) into a table using VBA.

Thanks




Miracles we do immediately ...
imposibilities take a little longer.

 

[poltergeist]

with chr(39) for single
and chr(34) for double

peterguhl@yahoo.de

 

[Fae]

This is the scenario :

'update temp table
'code snippet...
cm.CommandText = "insert into mytable (code, product) values ('" & strCode & "', '" & strProduct & "')"
cm.CommandType = adcmdText
cm.ActiveConnection = cnn
cm.Execute


Miracles we do immediately ...
imposibilities take a little longer.

 

[zemp]

Take a look at faq709-1526.

Thanks and Good Luck!

zemp