How about: (I reversed on set of quotes)
sqlstr = "INSERT INTO Jobs VALUES('" & txtSceneFile & "')"
> 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.