I am trying to append (insert data into a new table) that the data is being ported to. All the other data went fine for the other tables. With this SQL statement I am getting a type conversion error and cannot see why. The data also looks correct and the tables have the same column settings. Maybe someone can spot the error. I have included a pic of Tables and the error.
INSERT INTO tblEquipPanelBreaker ( keyEquip, numBreakerPosition, numBreakerDetailRow, strBreakerSize, optA103, strA103, keyCableDn, strPhase1, strPhase2 )
SELECT epb.keyEquip+10000000, epb.numBreakerPosition
, epb.numBreakerDetailRow, epb.strBreakerSize
, epb.optA103, IIF(epb.optA103 = 1, 'Y', 'N'), epb.keyCableDn+10000000
, epb.[Phase 1], epb.[Phase 2]
FROM tblEquipPanelBreaker1 AS epb, tblCable1 AS c
WHERE c.keyShip = 9 AND epb.keyCableDn = c.keyCable;