This is an automated import that has been working perfectly for a long time--now it isn't.
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ProcessSheets", sPath & xlFile, True, "IPP_Request!A5:AO5000"
Row 5 (top of the import range) contains the exact field names of the "ProcessSheets" table (so this stuff won't happen). There is no "yes" value in row 5. I searched the spreadsheet template and the only "yes" is in the header above the import range. I can't figure out what's changed. Any ideas?