Alteryx Designer

Definitive answers from Designer experts.

Microsoft Access .accdb Input

Alteryx
Alteryx
Created

Question

How come I cannot find my .accdb Access database when I use an Input Data Tool and try to search for it?

Answer

In order to open Access databases with the .accdb extension, you will need to download the Microsoft 2010 Office System Driver: Data Connectivity Components. Once you download and install, you will just need to close Alteryx if it is open and restart. You will then have 'Microsoft Access (.accdb)' as an option in the Input tool's File Browse drop down:

 

9-27-2016 2-17-03 PM.png

Comments
6 - Meteoroid

Do they have this for 2013? 

Alteryx
Alteryx

Hi @Lizzie. Sorry for the late reply. This should work for MS Access 2013 as well. Thank you!

6 - Meteoroid

Thanks!

Alteryx
Alteryx

Sure thing, @Lizzie!

6 - Meteoroid

We are having the same issue with Alteryx 10.1 and Office 2016.  We tried the Office 2016 Database Engine Redistributable and that didn't work.  Will this work for our setup?

16 - Nebula
16 - Nebula

@todd_henry I would download the 2010 Database Engine referenced in number 2 of this article. You will presumably want the 32-bit versions if you have a "normal" setup. 

5 - Atom

Hi,

 

To preface, I just started using Alteryx in the afternoon yesterday - it's fairly intuitive and I think I have a workflow largely the way I want it (Salesforce joined to MS Access, with 3 additional Access tables joined across by position), however when I reference my Access file, I don't see an option for a query in Access I've made. So far I haven't seen any literature referring to this, so how do I reference my Access query, or do I need to write SQL through Alteryx to push it up?

 

Any help appreciated,

 

Thanks,

7 - Meteor

Thank you!

5 - Atom

Hi, This solution worked and I was able to see MS access files while on Office 2016 but my company recently upgraded to Office 365 and it no longer works. I can see in my programs list that the Microsoft Access database engine 2010 (english) is still installed. Is that expected? or should it still be working?

Alteryx Certified Partner

Worked fine, Thanks!

Alteryx Certified Partner

Thank you

8 - Asteroid
Thank you good stuff, this worked for a colleague who was having a problem connecting to accdb files. We checked versions and 64 bit vs 32 bit and were confused that locally installed Access could open the files with no problems. We installed the data connectivity components and it worked immediately. The dead giveaway for this is if you can't see accdb in the list of available file types in the input tool. If you can see it there then you probably have a different problem.
8 - Asteroid

How would one work around this without Admin privileges on the computer?

5 - Atom

I have version 19.4 x64 with Office 2016 64 Bit. Unable to install the 32 Bit Microsoft Access Database Engine due to not having Office 32 Bit. 

 

Any way to get *.aacdb to show up in Alteryx with the Microsoft Access Database Engine 64 Bit install?