Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

connect mdb file an error occured

mathias_schnoor
11 - Bolide

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

 

 

 

 

 

 

 

 

2 REPLIES 2
JohnJPS
15 - Aurora

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
11 - Bolide

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