java - Inserting into Access database -

how resolve error in inserting memo in access java program?

4159 size of string

the error

java.sql.sqlexception: [microsoft][odbc microsoft access driver]count field incorrect

the source code executes insert statement:

statement.executeupdate("insert webdata values ("+"'" + list.get(y)+"','"+data+ "')");

4159 size of data

my schma :

table name webdata 2 coulmun

first id of type text

the second field1 of type memo

i have update statment have same error:

statement.executeupdate("insert webdata (id,field1) values ("+"'" + list.get(y)+"','"+data+ "')");

thank you

please post schema.

rather doing:

insert webdata values (...)

you should doing:

insert webdata (mycolumn1, mycolumn2) values (...)

do not rely on physical column order in table, should state explicitly avoid errors.

TY