unixODBC: Connect to .mdb in Linux?


Ah!! Like all the things which you leave and try to forget about .. come back and haunt you . .. there was this old project I was doing .. .(Tags: PDF creation, Servlets JSP, XML parsing, XLS reading) in the year 2007. Of late due to some unforeseen circumstances I had to exhume it & find what the ghost wanted.

Well the UI looked professional and I started exploring it but for some reason Eclipse on my Windows didn’t quite work properly… SVCHOST was eating up all the CPU. So I had to give it a thought to migrate to Ubuntu. But there was this big blocker… ODBC on Unix….     [and the story continues ….]

Stuff I told synaptic to download:


Configuration done using this Link.


Description = MDB Tools ODBC
Driver = /usr/lib/libmdbodbc.so.0
Setup =
FileUsage =
CPTimeout =
CPReuse =


Description = Microsoft Access Try DB
Driver = MDBToolsODBC
Database = /home/nikunj/programming/logindb.mdb
Servername = localhost
Username =
Password =
port = 5432

Done?: (not yet)

nikunj@ubuntu-desktop:~$ isql logindb
| Connected!
| sql-statement
| help [tablename]
| quit
SQL> select name from profile
| name
| Mukesh Kumar Lahoti
| Nikunj Lahoti
| OneTwoThreeFour
| OneTwoThreeee
| M K Lahoti Ji
SQLRowCount returns 5
5 rows fetched

Now [TODO]

1) Connect Java to this ODBC

2) Use MS Excel Connector for Unix+Java.
The Java Excel API is an open source Java API which allows Java developers toread Excel spreadsheets and to generate Excel spreadsheets dynamically.