Java and MS Access

445 Views Asked by At

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 that It cannot execute SQL queries is there any alternative for using MS Access and Java?

1

There are 1 best solutions below

1
On

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.