• Products >
• Support >
• Solutions
• Company
• Blog

• < Back
• ODBC drivers >
• JDBC drivers >
• Bridges, gateways >
• Other >
• All products

• < Back
• JDBC-ODBC Bridge
• JDBC-Access Gateway

• < Back
• ODBC-ODBC Bridge
• ODBC-JDBC Gateway
• dbExpress-ODBC Gateway
• XML-ODBC Server

• < Back
• ODBC-ODBC Join Engine
• SDK
• Consultancy
• Roadmap

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.