I am trying to upadate and access db with SQL and I keep running into Update syntax error?
Here is the code I am using
sqlqry = "UPDATE eurusd SET HIGH =" + Str(vHigh) + ", LOW =" + Str(vLow) + ", OPEN =" + Str(vOpen) + ", CLOSE =" + Str(vClose) + ", TIME =" + Str(vTime) + " WHERE ID =" + Str(ry)
Set RS = Conn.Execute(sqlqry)
when I print the string out eveything seems to be fine? Not sure what I am doing wrong here?