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 Gateway to work with Microsoft Access data.

Installing the Easysoft JDBC-Access Gateway

1. Download the JDBC-Access Gateway.
2. Install and license the JDBC-Access Gateway on the machine where Wolfram Mathematica is installed.

   Install the JDBC-Access Gateway into the default folder.

   For installation instructions, refer to the JDBC-Access Gateway 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.