C
carmen
I am trying to get an SQL statement to work in hard
coding some data into an Access database. When I tried an
INSERT statement I recevied an error message to use and
updatebale query. So I then used the following UPDATE
statement and was told my syntax was in error. Can anyone
help me in properly stating this query? Thanks in advance.
struSQL = "UPDATE Sessions SET
(EventDateTime,URL,SessionID) VALUES ('" & Now() & "','"
& strURL & "','" & strSession & "')"
coding some data into an Access database. When I tried an
INSERT statement I recevied an error message to use and
updatebale query. So I then used the following UPDATE
statement and was told my syntax was in error. Can anyone
help me in properly stating this query? Thanks in advance.
struSQL = "UPDATE Sessions SET
(EventDateTime,URL,SessionID) VALUES ('" & Now() & "','"
& strURL & "','" & strSession & "')"