Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Cannot see .accdb as an option for data input

Mattbeatty89
6 - Meteoroid

I need to pull in some data from an Access db (.accdb) but it is not showing as an option.  Has anyone else experienced this issue and found a way to get the data in?  

 

I am using Alteryx Designer 10.5 x64

 

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor

My first guess would be to install the Access Database Engine that this post describes. We ran into this issue when we upgrade our MS Office products. Be careful about the 32/64 option as we're running 64 bit Alteryx on a 64 bit machine but needed to install the 32 bit Access Database Engine for this to work.

 

Do let me know know if that doesn't fix your issue!

 

Patrick

Mattbeatty89
6 - Meteoroid

Thank you so much for the quick solution!  I had searched around the community some before posting and tried installing a couple suggested things from another post regarding xlsx and accdb but it either didnt work or I installed the incorrect version. 

 

However this worked great, thank you for the caution regarding which bit to select as well.

 

Have a great day!

Labels