Syntax error for INSERT INTO WHERE statement

Been a tough week for bugs. This code looks good but fails. Any insights
would be appreciated

Dim strQuote As String
Dim str As String
Dim strQuote3 As Long

str = "INSERT INTO 2007TourneyResults([week2]) VALUES " _
& strQuote3 & " WHERE [playerid] = '" & strQuote & "'"
Debug.Print str
CurrentDb.Execute str, dbFailOnError

table 2007TourneyResults
field week2 long integer
field playerid text

here's the string it's returning

INSERT INTO 2007TourneyResults([week2]) VALUES 630000 WHERE [playerid] =
'00/65/67/'

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200701/1

.

Relevant Pages