[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition

anupvix

New Member
I am accessing an Access database inside a java program, however I get an error when I execute the sql command:\[code\]static String SQLCreate = "CREATE TABLE CONTACT_INFO (" + "Contact_ID INTERGER NOT NULL PRIMARY KEY," + "First_Name VARCHAR(20) NOT NULL," + "MI CHAR(1)," + "Last_Name VARCHAR(20) NOT NULL," + "Street VARCHAR(50) NOT NULL," + "City VARCHAR(2) NOT NULL," + "ZIP VARCHAR(10) NOT NULL);";\[/code\]I cant see anything wrong, maybe a new set of eyes will help.Thanks in advance.
 
Top