Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

XLS format format to be changed to xlsx

mmustkee
10 - Fireball

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.

8 REPLIES 8
RSreeSurya
9 - Comet

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
10 - Fireball

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

RSreeSurya
9 - Comet

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. 

 

RSreeSurya_0-1685620062892.png

 

Please have a look

 

jdminton
12 - Quasar

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
10 - Fireball

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.

mmustkee_0-1685621629992.png

 

RSreeSurya
9 - Comet

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. 

 

RSreeSurya_0-1685621744319.png

 

Let me know if you are facing any challenges. 

 

atowns100
5 - Atom

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

ravi061
8 - Asteroid

Hi,

 

How you resolved that error?

I am facing the same error

Labels
Top Solution Authors