View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markantesp Markantesp is offline
external usenet poster
 
Posts: 9
Default Syntax Error help

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.