SQL Update in VBA

[kuehlcr]

Hello all

I have been working on an update querie in VBA to update my SQL 2005 server, but I can't seem to make it work, so I think I need a second set of eyes.

Please Login or Register  to view this content.

I keep getting the same error Incorrect syntax ner "=", debugging shows strSQL = Update tblAttendance_Count[][]Set userID= '31'[][]Set sDate='4/21/2010'

I have never used SET in VBA before so I am not sure I am using it properly.

[DonkeyOte]

see: http://www.w3schools.com/sql/sql_update.asp

In general terms: one SET command with fields being updated delimited by comma - ensure you add spaces between values / keywords as necessary