Skip to content

Instantly share code, notes, and snippets.

Avatar

Brandon Istenes brandones

View GitHub Profile
@shapr
shapr / dbexport.py
Created May 27, 2014
Jython: use Jackcess to csv export all the tables from whatever Jackcess supports, including Access 97, 2000, 2003, 2007, 2010
View dbexport.py
# required apt-get install jython libcommons-logging-java libcommons-lang-java
import sys
sys.path.append('jackcess-2.0.4.jar') # assume the jackcess is in the same directory
sys.path.append('/usr/share/java/commons-logging-1.1.3.jar') # in case logging didn't get picked up
sys.path.append('/usr/share/java/commons-lang-2.6.jar') # in case lang didn't get picked up
from com.healthmarketscience.jackcess import *
from com.healthmarketscience.jackcess.util import ExportFilter
from com.healthmarketscience.jackcess.util import ExportUtil
from com.healthmarketscience.jackcess.util import SimpleExportFilter
import java.io