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 Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

IN-DB Data Connection with access database

faizannandwani
5 - Atom

How can I have In-DB connection with MS Access DB. It doesn't give Access option in source data drop down menu. Any assistance shall be appreciated. Thanks.

1 REPLY 1
dataMack
12 - Quasar

The IN-Database connectors are advantageous for massive database systems where moving data across the network to process it would be very time consuming.  Why not take advantage of your large database cluster to do the processing- that's what it was designed for!

 

MS Access is a bit different in that it's not really a database- it's basically local files, so there's nothing to be done 'in database' - you just need to read the files in, and for that a standard Input tool should work fine.

 

If you want to have Alteryx help you write the query against multiple tables in your MS Access file, then try using the 'Visual Query Builder' option when connecting to it within the standard input tool.