Hi all,
I have a number of .xls files containing some parking data which I am hoping to read into Alteryx simultaneously. A few of them read into Alteryx without issue, but most produce the following error message when attempting to select a table in the .xls file:
This is despite the fact they are seemingly the exact same file schema. I have attached a .yxzp file which demonstrates 1 file that is inputting correctly (2021.03 car parking base data.xls) and 2 which are causing errors. All files are of the same schema.
Please note that I do have the x32 bit Microsoft Access Database Engine 2010 installed on my machine from this link. This has worked for me in the past but does not seem to be resolving the issue I am experiencing here.
Could anyone please provide some insight into this issue?
Edit: Interestingly, the files are successfully read into the workflow when I have them open in Excel, but the error persists when I close them - not sure whether this helps in diagnosing the cause of the issue.
