Drop the extra ampersands (&) and add spaces before VARCHAR.. ??

cnn.Execute _
"CREATE TABLE tblOutput(" & _
Field1 & " VARCHAR NOT NULL, " & _
Field2 & " VARCHAR(20) NOT NULL, " & _
Field3 & " VARCHAR(20) NOT NULL)"



"Markantesp" wrote:

I'm blanking out right now........I'm receiving a syntax error message when I
run this statement...

cnn.Execute _
"CREATE TABLE tblOutput(" & _
& Field1 & "VARCHAR NOT NULL," & _
& Field2 & "VARCHAR(20) NOT NULL," & _
& Field3 & "VARCHAR(20) NOT NULL)"


Field1, Field2, Field3 are variables.