connect mdb file an error occured

Question

Hi!

I want to load an Microsoft Access .mdb file with the Input Data Tool.

But when I try to connect  I get the error message:

The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine

When I connect the an .accdb Access file. I works fine.

MS Access is not installed on my local machine. I have installed: AccessDatabaseEngine_X64

Im use Alteryx Designer 10.5.9.15014

What is the reason?

Mathias

JohnJPS · Accepted Answer

Hi @mathias_schnoor,

This may involve installing a redistributable package on your machine for the version of .mdb file you're using.  There are a number of suggestions regarding this error message here and various other help sites like MSDN.  The most common solution being to download and install a package from Microsoft: https://www.microsoft.com/en-us/download/details.aspx?id=13255.  Hope that helps!

mathias_schnoor · Accepted Answer

Hi!

Thank you for your references.

Now I have connected an Access .mdb file in Alteryx. But the connect works only an ODBC connect.

I have setup:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

...

If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”

...

Mathias