New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

How to open an MS Access file

Taylor
Level 2
How to open an MS Access file

I know it's been a while since this was asked, but is there a way to set up a connection like this if the .accdb file exists in a DSS managed folder?
/apps/DATA_DIR/managed_folders/<project_key>/<folder_object_id>/<databasename.accdb>
That is what I just tried but I'm getting an IO error message that says this is actually a directory.

0 Kudos
2 Replies
rikro
Level 2

For me it works from a DSS managed folder. Are you sure your path is correct?

Also check for the JDBC driver version, not sure what else doesn't work inside dataiku: https://community.dataiku.com/t5/Using-Dataiku-DSS/Connect-to-MS-Access-file-with-Date-Time-data-typ...

0 Kudos
CoreyS
Community Manager
Community Manager

A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos
A banner prompting to get Dataiku DSS