Hi,
I am trying to input all tables from a Microsoft access database into Alteryx. I've tried using a union statement but that keeps throwing this error:
I have also tried to look up a solution on the community page and the only thing i found referenced a batch macro. the person who proposed the question seemed to have the same issue as me with the batch macro. He could not figure out how to get the list of table names. Another use then posted a Microsoft article on how to get the names of the tables out of the access file. I did not find this helpful because i have many access files that i need to do this for and do not want to go through one by one extracting the table names. it would be much more efficient to set up a solution for one file and then copy for each file. Can anyone post an example of how they are able to get all tables exported out of a Microsoft access database and pushed into a .yxdb?
