cyborgski
New member
- Joined
- May 12, 2019
- Messages
- 61
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I frequently work with Excel files that are generated from Oracle. These files appear to be HTML with a .xls extension. When I attempt to use PowerQuery to read the file, I get the message "External table is not in the expected format." When I attempt to read as an HTML, PowerQuery does not read the file properly either. The only success that I have had is opening from Excel and saving over the file. I can the read the file in PowerQuery as an Excel file.
Has anyone had a similar experience and would you have a more direct approach?
Thank you,
Mike
Has anyone had a similar experience and would you have a more direct approach?
Thank you,
Mike