Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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