Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

.XLS files in input

moblender
7 - Meteor

Hi everyone, hoping to find a solution to the .xls input file problem. I'm running 64bit version of Microsoft products on my company pc (required) and have downloaded the 64bit access database engine but still cannot use .xls files as an input option. I've tried using the legacy file type option and that does not work either. When trying the 32bit access database engine, I'm prompted to install 32bit version of microsoft products which just isn't an option. Is there any fix for this? Opening and resaving .xls files is getting pretty old considering most of my files come from SAP and are exported as .xls. Thanks for any help

4 REPLIES 4
npariso
10 - Fireball

Could you possibly export the data from SAP to a CSV file and use that as an input? Then downstream you could process the CSV into an xlsx file?

moblender
7 - Meteor

I think (I may be wrong) that SAP will only export spreadsheet as text in either .txt or .xls formats

npariso
10 - Fireball

We might be able to solve this if there are any other output formats other than just xls and txt. Can you check what the other options are?

moblender
7 - Meteor

looks like there may be an .xlsx output. i'll have to test this out.

Labels