I have a .sdb extension format smallsql database created by Open Data Kit briefcase.
It is a java based database.
I would like to import or link to it using a Microsoft Office Access 2010 database in either .mdb or .accdb version without exporting to .csv and cleaning.
I need help figuring out how to link to it using ODBC (JDBC ?) on a Windows 7 Professional 64 Bit machine (MS office is 32 bit).
Some thoughts http://www.aptivate.org/en/blog/2011/12/05/rough-guide-to-rural-data-collection-with-odk/