XLS format format to be changed to xlsx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That helps but do we have any knd of macro which can convert all these files to .xlsx format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To anyone receiving this error, close excel in your task manager and that should do it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
How you resolved that error?
I am facing the same error
