Forum Discussion

JulesHan's avatar
JulesHan
Frequent Visitor
2 years ago

Unzip XLS file from Oracle in Power Query

Dears,    I'm struggling for a while with this one. I already watched numerous youtube videos and read multiple blogs but nothing worked so I hope someone can help me with this.   I would li...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
2 years ago

ZIP files come in different formats, sizes, and number of children.  What's the difference in characteristics for your ZIP files?  More than 2GB? More than a single file?  Directory only at the beginning or also at the end?

JulesHan's avatar
JulesHan
Frequent Visitor
2 years ago

All zip files contain 1 XLS file and the size varies. Maybe the ZIP files are too large?

 

 

I also get the following message when I try to open them (but when I click 'yes' the XLS file opens without errors):

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    No, these files are tiny, the limit is 2GB. 

    Are these files Text/CSV with the wrong extension?

    • JulesHan's avatar
      JulesHan
      Frequent Visitor
      2 years ago

      If I check the properties of these files it says excel workbook:

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Yet Excel complains - do you have a HEX editor that you could use to peek at the bytes?