CODEWITHSUNDEEP
javaodbc
Rpant
Rpant

Reputation: 1054

Error while inserting through odbc driver

What can be possibly wrong in the following statement trying to insert into ms accses

   insert into mytable("Submission","Applicants Email", 
              "Applicants - 1") 
   values("abc school district","[email protected]",
              "Incomplete")

While trying to execute through java odbc driver . i am getting:

         java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[[email protected]]'.

Upvotes: 0

Views: 548

Answers (1)

Rpant
Rpant

Reputation: 1054

In access values need to be in single quotes , it seems , here is what worked for me

Thanks everyone for your time.

Upvotes: 2

Related Questions