Unable to combine files extracted from Oracle ERP using power query

[sekharks]

Dear Experts,

In my office we use Oracle ERP and we require to combine some files (max of 250 files) into one excel workbook.

If the downloaded format of the file is CSV, power query editor doesn't show any messages and combines the files as required.

The problem arises only when the files are downloaded in .xls format. Every time when I try to combine the files power query displays a message "External table is not in the expected format"

Then i have to change the files to original Excel format one by one and combine them using power query.

I request the experts to suggest me how to change multiple files extensions to actual excel format from .htm (web page) format which saves my time.

Attaching the original file and converted files for your easy understanding.

[sandy666]

ask Oracle manager (?) to change the format of files like this, there is much more JavaScript and frames than data.
or use Command Prompt (cmd.exe) with this : rename *.xls *.htm and it will change all extensions xls to htm

[sekharks]

Dear Sandy666,

Apologies for delayed response.

I have tries Bat file and command prompt to change the file extensions but everytime a message displayed that the file is corrupted and check.

Then I tried the Convert option within the file and it worked like charm and was able to finish my job using PQ.

Thank you for your valuable suggestion.

[sandy666]

hm, it works for me with cmd, but if you found solution that's great
welcome and thanks