Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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....
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....
I did not know that all XLSX are zip files.
Thank you for your help
Bob