community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

List of Tables in Ms Access

Hello. 

How can I get the list of tables present in Ms Access database in Alteryx.

Thanks!!!

Moderator
Moderator

Hi @sneha_bhiwagade1,

 

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.

 

Kind regards,

 

Paul Noirel

Sr Customer Support Engineer, Alteryx

Labels