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
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-string-ACCESS/td-p/143676
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-to-MS-Access-error/td-p/402935
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?
@Per
If I do that I get bellow error:
Any idea how to solve that?
