Provides automated conversion of MS Access 2000 databases to SQLite on any platform, utilizing Jackcess and SQLite Java libraries. No native driver required.
MDB-SQLite is used by Plausible Labs to read government-supplied Access databases.
This repository was created to fork and maintain the original abandoned code on https://code.google.com/p/mdb-sqlite/
To compile, run:
mvn package
This will create a standalone jar in target/mdb-sqlite-{#}.one-jar.jar
To convert a database file:
java -jar target/mdb-sqlite-{#}.one-jar.jar source.mdb output.sqlite
1.0.3 Release
- Moved to Maven project structure on github
- Updated dependencies
- Patched for explicit Float/Double support per https://code.google.com/p/mdb-sqlite/issues/detail?id=11
- Logging output added per https://code.google.com/p/mdb-sqlite/issues/detail?id=11#c11
1.0.2 Release
- Prefix index names with the table names to prevent name conflicts when converting indixes.
1.0.1 Release
-
Work-around around the SQLite JDBC drivers lack of support for boolean values ( Issue #2 )
-
Add support for converting indexes ( Issue #3 )
1.0 Release
- Initial Release