Insert statement from Java programme.

[newJack12]

how do i insert a variable from my java programme as a value for a field in an access db. I have tried the following code where imagePath is the variable.
stmt.executeUpdate("INSERT INTO Images ( path,keyword1) VALUES (imagePath, landscape)");

 

[lameid]

First you are off topic as you are asking a JET (Access) SQL question in an Access as a Front End to SQL forum.

Secondly I don't know how you'd send a SQL command from JAVA.

The Syntax for a JET query to append literals would look soemething like the following.

Insert Into Images (Path, Keyword
Select ImagePath as expr1, Landscape as expr2