Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

connect mdb file an error occured

Highlighted
Alteryx Partner

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

 

 

 

 

 

 

 

 

Highlighted
ACE Emeritus
ACE Emeritus

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!

Alteryx Partner

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

 

Labels