Skip to content

Instantly share code, notes, and snippets.

@pbdanny

pbdanny/MSAccessJayDeBeAPI.py

Created July 7, 2017 10:30
Show Gist options
  • Save pbdanny/f75ffbf37bc8e66014371bf6460e1ddf to your computer and use it in GitHub Desktop.
Save pbdanny/f75ffbf37bc8e66014371bf6460e1ddf to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. pbdanny created this gist Jul 7, 2017.
    38 changes: 38 additions & 0 deletions MSAccessJayDeBeAPI.py
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,38 @@
    import jaydebeapi

    # Initiate Java runtiome file location

    ucanaccess_jars = [
    "/Users/Danny/Documents/UCanAccess-4.0.2-bin/ucanaccess-4.0.2.jar",
    "/Users/Danny/Documents/UCanAccess-4.0.2-bin/lib/commons-lang-2.6.jar",
    "/Users/Danny/Documents/UCanAccess-4.0.2-bin/lib/commons-logging-1.1.1.jar",
    "/Users/Danny/Documents/UCanAccess-4.0.2-bin/lib/hsqldb.jar",
    "/Users/Danny/Documents/UCanAccess-4.0.2-bin/lib/jackcess-2.1.6.jar",
    ]

    # classpath = $PATH$ parameters for Java runtime file location

    classpath = ":".join(ucanaccess_jars)

    # Initate connection to MS Access files
    cnxn = jaydebeapi.connect(
    "net.ucanaccess.jdbc.UcanaccessDriver",
    "jdbc:ucanaccess:///Users/Danny/Share Win7/2017OSSDatabase.accdb",
    ["", ""],
    classpath
    )

    # From connection initiate cursor
    crsr = cnxn.cursor()

    # Run Query
    crsr.execute("SELECT * FROM Region_KTC")

    # Fetch Query result
    for row in crsr.fetchall():
    print(row)

    # Close cursor
    crsr.close()
    # Close connection
    cnxn.close()