Error in Execute Query for MS Access

Help
1

Hi,

I am trying to execute a basic MS access query using however, I am getting an error during typing it in Eqit SQL as my query has " as a part of the condition.

Can you please suggest a way around this as I am new to UIPath.

Error
Error1780×613 71.1 KB

2

Hi Sayan,

The solution to your issue would be “escaping” the double quotes in your string. To do this, you simply enter "" where you would like a double quote to appear. For example, if I defined a string as "hello ""world""" it would be printed out as: hello "world".

For more information on this, you might want to check out this Stack Overflow page here: https://stackoverflow.com/questions/4835691/escape-double-quote-in-vb-string

Hope this helps!

Evan

3

Hi Evan,

It helped solve my problem.

Thanks a ton.