The JDBC-ODBC driver doesnot support the same charsets that MS Access using for other then latin characters, thus I cannot read hebrew from the database, which is mostly written in hebrew(a bug report is written here ) I tried using Jackcess for reading from the database but then I've understood tha开发者_如何学运维t It cannot execute SQL queries is there any alternative for using MS Access and Java?
You could always export the Access database into something else - MySQL, for example, there are a few converters around. Then you could use the MySQL JDBC driver.
精彩评论