bad syntax?

[MacataQ]

hello
i am tryig to get my vb form to creata new table in an existing db
i am using the following code

Option Explicit
Private Sub cmdCreateTable_Click()
Dim conScores As ADODB.Connection
Dim strSQL As String
Set conScores = New ADODB.Connection
conScores.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source='C:\temp\db3.mdb'"

strSQL = "CREATE TABLE scores (" & _
"Option1 bit," & "option2 bit," & "opt3 bit," & "opt4 bit," & "opt5 bit," & _
"opt6 bit," & "opt7 bit," & "opt8 bit," & _
"opt9 bit" & "opt10 bit," & "opt11 bit," & _
"opt12 bit," & "opt13 bit," & "opt14 bit," & _
"opt15 bit," & "opt16 bit," & "opt17 bit," & _
"opt618 bit," & "opt19 bit," & "opt20 bit," & _
"opt21 bit," & "opt22 bit," & "opt23 bit," & _
"opt24 bit," & "opt25 bit," & "opt26 bit," & _
"opt27 bit," & "opt28 bit," & "opt29 bit," & _
"opt30 bit," & "opt31 bit," & "opt32 bit," & _
"opt33 bit," & "opt34 bit);"

conScores.Execute strSQL ' i get the error here


MsgBox "A table named Scores has been added to the db3.mdb database"

Set conScores = Nothing
End Sub
i get "sytax error in field defintion"
what have i missed
Mac

[pclement]

You're missing a comma:

"opt9 bit," & "opt10 bit," & "opt11 bit," & _

[MacataQ]

omg , what a dope i am
cant see whats in front of me..lol
thanks Paul

[mstraf]

jeez Paul, you DO have a good eye!
In cases like this, I prefer to create my command string in a loop, because I know that I will miss something... besides my eyesight
Marco

[pclement]

Yeah, I only spent about five minutes looking at the statement before I finally noticed the missing comma. ;-)