# Utilizing MS Access in Dataiku DSS[¶](https://knowledge.dataiku.com/latest/kb/exploration/Utilizing-MS-Access-in-Dataiku-DSS.html#utilizing-ms-access-in-dataiku-dss "Permalink to this headline")

Many of our users have shown interest in utilizing MS Access in Dataiku DSS. In the interest of knowledge sharing, we wanted to demonstrate how to do just that.

## How to open an MS Access file[¶](https://knowledge.dataiku.com/latest/kb/exploration/Utilizing-MS-Access-in-Dataiku-DSS.html#how-to-open-an-ms-access-file "Permalink to this headline")

* Download ucanaccess

* Copy `ucanaccess-4.0.4.jar` and `jackcess-2.1.11.jar` (including the ones from lib/) into `DATA\_DIR/lib/jdbc/` (see Installing database drivers for more details)

* Restart DSS.

* Configure a new connection:

>

>

> 	+ JDBC driver class: `net.ucanaccess.jdbc.UcanaccessDriver`

> 	+ JDBC URL: `jdbc:ucanaccess://<filepath>` , e.g. `jdbc:ucanaccess:///home/johndoe/Documents/fooDB.accdb`

> 	+ In the “SQL Dialect” field, select “MySQL < 8”

>

* Create a new dataset using this connection to import an MS Access table in DSS.

## Connecting to MS Access file with Date/Time data type[¶](https://knowledge.dataiku.com/latest/kb/exploration/Utilizing-MS-Access-in-Dataiku-DSS.html#connecting-to-ms-access-file-with-date-time-data-type "Permalink to this headline")

Be sure to follow the above steps, but utilize UCanAccess 4.0.4
