Anyone knows how to enter a string like

' Juan's birthday ' via JDBC query like

insert into table(name) values ('Juan's birthday')

What is the escape letter in Access? Any advice would be helpful!

Jing

Enclose it in double quotes instead of single quotes?

I don't think that will work, but thanks anyway.

My code is like the following:
******************************
statement stmt;
...

String insert="insert into table (name) values ('juan's birthday')";
....
stmt.executeUpdate(insert);
*******************************

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=27690

hai ruuram


if you still need that question please send me a mail to ramesh_srinivasan123@rediffmail.com

i have the answer ready for u
raemsh