Link Database table within the Database

[Pascal_R]

Hi all,

Can someone guide me how to link an Access table? I choosed Input Data--> Files --> Microsoft  Access .accdb but there is now window to choose the specific table.

Thank you for support.

Regards,

Pascal

[Per]

Hi,

There should be a window popping up as you say. Could try to drag and drop the file into the workflow? It should default to using a table I believe:

Otherwise, the .accdb might not be valid for whatever reason. Try creating a new .accdb file with dummy data to see if that works perhaps?

[Pascal_R]

@Per 

If I do that I get bellow error:

Any idea how to solve that?

[Per · Accepted solution]

Hi @Pascal_R 

As suspected, there is an issue with the database itself. Try and see if these links might be helpful as you are not the only one it seems 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Output-Error-opening-connect-str...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-to-MS-Access-error/td-p/402935