0

I am accessing an Access database inside a java program, however I get an error when I execute the sql command:

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);";

I cant see anything wrong, maybe a new set of eyes will help. Thanks in advance.

RandellK02
  • 167
  • 1
  • 4
  • 17

1 Answers1

2

You have a typo. Replace INTERGER with INTEGER and it should work.

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
  • Thanks, I knew I needed some fresh eyes. – RandellK02 May 26 '12 at 07:39
  • There's a [campaign to clean up Stack Overflow](http://meta.stackexchange.com/q/167342) by removing these typo-related questions, we could really use your help! Would you mind pitching in a little by casting a close vote on this question? – Wesley Murch Mar 07 '13 at 13:58