Accdb not seen in 11.5 version

[marcin2x4]

Hello!

Brief machine, software background:

Windows 7 (64 bit)

Office 360 Plus (32 bit)

Alteryx 11.5 (64 bit)

Issue - alteryx doesnt see accdb format.

Question - Would installing below driver fix the issue (64bit or 32bit)?

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

[patrick_mcauliffe]

@marcin2x4

It could.  For the MS File formats (accdb, xlsx, etc) its generally a "try it and find out".  Doesn't hurt anything to install, check, and then uninstall if it didn't work.

Generally the file formats issue is fixed by the 2010 version (https://www.microsoft.com/en-us/download/details.aspx?id=13255) but I don't have 365 to confirm it doesn't break anything with that.  I'd start with the 2016 version and work your way back in time if that doesn't fix it.

[marcin2x4]

@patrick_mcauliffe

Is there a way to workaround this issue without installing the package?

[LordNeilLord · Accepted solution]

There is a thread here about the issue:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Microsoft-Access-accdb-Input/ta-p/34051

[patrick_mcauliffe]

@marcin2x4

Without the Access Database Engine (driver package), non-Microsoft applications don't have the connection information they need to recognize those formats.

TLDR; No.  You need some version of that installed.