Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ZIP ERROR?

It worked ok the first time but when I pasted two files with data in them I get a Zip Error?

LOAD

    FACILITY,

    "EMPLOYEE ID",

    HIREDATE,

    TERM_DATE,

    PAYTYPE,

    "WORKED DATE",

    "HOURS",

    "JOB TITLE CODE"

  

FROM [lib://PBJ Reports (pharmore_rwinkel)/*.xlsx]

(ooxml, embedded labels, table is Contractor_Data_Entry);

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Any XLSX file is a ZIP-file. Maybe your XLSX-file was corrupt and that is why you get the error message.

You could try to make a copy of both of your Excel files and change the extensions from XLSX to ZIP. Then try unzipping both of them and see if Windows report any ZIP-error....

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

Any XLSX file is a ZIP-file. Maybe your XLSX-file was corrupt and that is why you get the error message.

You could try to make a copy of both of your Excel files and change the extensions from XLSX to ZIP. Then try unzipping both of them and see if Windows report any ZIP-error....

Not applicable
Author

I did not know that all XLSX are zip files.

Thank you for your help

Bob