I am chunking through some XML lines to extract the Fieldname and Value (using MID statement), and then writing the result to an Access Table. This is working just fine UNTIL I encounter data that contains a single quote.
<desc>It's No Hoover! by markp99, Traditional (2/2)</desc>
I can collect the fieldname "desc" and its value "It's No Hoover! by markp99, Traditional (2/2)"
But when I attempt to insert the VALUE into an Access table using:
myValue = "It's No Hoover! by markp99, Traditional (2/2)"
SQL = "INSERT INTO myTable (desc) VALUES ('" & myValue "')"
I get an error msg, I am pretty sure because the single quote (') is being enterpreted and a delimiter.
What should I do to the VALUE string to retain, but ignore, the single quote (')?
Note that I am processing 25K to 100K (or more) lines, so I would prefer not to do any global or line-by-line search and replace. An incremental performance "tax" will get multiplied...