This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I try once again, and now a new error pops up. "Error opening connect string: Microsoft Access Database Engine: External table is not in the expected format.\3274 = -328602519. I need help. Any ideas? I am using Alteryx version 2018.3.4.51585
Yes, it loads just fine in excel. Unfortunately I cannot upload an example as I am using OCR technology to capture sensitive data and export them to XLS. If I edit just a single byte of data by myself from the file and then save it, then it can be imported. But that does not solve the underlying issue. I need to be able to import it without re-saving it.
This to me seems like the system you are using to Export it isn't creating the XLS file quite right, as re-saving it fixes the issue due to Excel itself creating all the underlying parts needed.
Is there anyway you could export it as XLSX instead?
The parts that you mentioned you installed are the parts that Alteryx is using, so it's not actually Alteryx itself that is getting the error is the Access Database Engine. I appreciate this doesn't help you fix it, but hopefully helps you understand what's going on.