XLS format format to be changed to xlsx

[mmustkee]

Hi Team,

I have multiple files more than 50 in .xls format which I want to combine and receiving attached error. Please advise a way out.

[RSreeSurya · Accepted solution]

Hi @mmustkee ,

Please refer the below article. This should resolve the issue.

https://community.alteryx.com/t5/Engine-Works/Access-Driver-Install-for-xls-File-Acess/ba-p/90145 

[mmustkee · Accepted solution]

That helps but do we have any knd of macro which can convert all these files to .xlsx format

[RSreeSurya]

Hi,

I have developed Python code and by utilizing the code in embedded Python tool in Alteryx, we will be able to achieve this.

The code converts xls to xlsx and deletes the original xls file .

If you don't want to delete the xls file, please remove below line from the Python code. 

Please have a look

[jdminton]

I ran into this issue previously. The error is related to Microsoft Office 32 bit versus 64 bit files. If you download the Access engine from Microsoft, this will resolve the issue. https://www.microsoft.com/en-us/download/details.aspx?id=13255.

[mmustkee · Accepted solution]

Thanks for the solution.

How will I add my .xls files into the workflow and where will be output in .xlsx format.

I am receiving below error.

[RSreeSurya · Accepted solution]

Hi,

In the text input, you can add the file paths and in the same folder , with same filenames .xlsx files will be created . xls files will be deleted. 

Let me know if you are facing any challenges. 

[atowns100]

To anyone receiving this error, close excel in your task manager and that should do it.

[ravi061]

Hi,

How you resolved that error?

I am facing the same error

[dunkindonut7777]

not working on my end. can you elaborate the instruction on the text tool part? Or atleast make a sample