Easysoft Blog

Mon, 26 March 2018

Using Microsoft Access Data in Wolfram Mathematica

Wolfram Mathematica can use data that can be retrieved through a JDBC connection. For example, you can use Wolfram Mathematica with the Easysoft JDBC-Access Driver to work with Microsoft Access data:

Installing the Easysoft JDBC-Access Driver

  1. Download the JDBC-Access Driver. (Registration required.)
  2. Install and license the JDBC-Access Driver on the machine where Wolfram Mathematica is installed.

    Install the JDBC-Access Driver into the default folder.

    For installation instructions, see the JDBC-Access Driver documentation.

Connecting Wolfram Mathematica to Microsoft Access

  1. In a Mathematica Notebook, add the following code. Update the JDBC-Access Gateway JAR (esmdb.jar) and Access database paths as appropriate.
    Needs["JLink`"]
    AddToClassPath["C:\\Program Files\\Easysoft Limited\\Easysoft JDBC-Access Gateway\\Libs\esmdb.jar"];
    Needs["DatabaseLink`"];
    
    conn = OpenSQLConnection[
     JDBC["easysoft.sql.esMdbDriver", 
      "jdbc:easysoft:mdb?DBQ=C:/Users/Public/Documents/Northwind.mdb"]]
    
    SQLConnections[]
    
    SQLTables[conn]
    
    CloseSQLConnection[conn];
  2. From the Evaluation menu, choose Evaluate Notebook.

    A list of tables in the Access database is returned.