Re: "INSERT INTO" dropping slashes from strings

[Steve Pugh]

Err...what I meant to say here was "ascii code equivalent (chr(39)" (I 
tried single *and* double quotes).  Sorry about that.

Steve Pugh wrote:

> Hi Daniel,
>
> I tried that to no avail (I had actually had the code set initially to 
> use single quotes thusly:
>
> sqlstr = "INSERT INTO Jobs VALUES("' & _
>         txtSceneFile & "')"
>
> but it generated the same erroneous string.  Using the ascii-code 
> equivalent (Chr(34) does the same.