This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How can I get the list of tables present in Ms Access database in Alteryx.
Thank you for posting!
As you you will not be able to list the tables of a Ms Access file directly from Input Data tool, you could use a method like the one mentioned there: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Microsoft-Access-List-Tables/m-p/62898.... Or, you could also use an intermediate VBScript (an example of code is available there : https://blogs.technet.microsoft.com/heyscriptingguy/2006/06/08/how-can-i-list-all-the-tables-in-an-a...) and run it via a Run Command tool.
Sr Customer Support Engineer, Alteryx