Aginity for Netezza Create Temp table from external xlsx file using ODBC

In Agignity Workbench for Netezza I am trying to create a temp table from an .XLSX file containing 13 columns, but I only need columns 1 and 5. I can export to a tab delimited .TXT with two required columns and it works fine, but I would like to avoid the conversion from the original file as it is regularly updated and others can run this file. Must be TEMP TABLE and must be XLSX. A subsequent query will add the temp table.

I have the following request:

CREATE TEMP TABLE office AS
(SELECT zip_code, DISPATCH_LEVEL
FROM EXTERNAL 'file.xlsx'
        (zip_code VARCHAR(10), DISPATCH_LEVEL VARCHAR(100))
        USING (REMOTESOURCE 'ODBC' DELIMITER '\t'));

      

        
        
        
      

    

I am getting the following block of errors:

ERROR [HY008] Operation canceled
ERROR [01000] Failed to write nzlog / bad files
ERROR [01000] Failed to write nzlog / bad files
ERROR [HY000] ERROR: External table: the number of failed input rows has reached the maxerrors limit