Please assist. unable to identify problem. I realize it's a lot. can question marks in table field names be the problem? or times in the dates (table set to mm/dd/yyyy)? ps. both INSERT and UPDATE commands have same error.
From Immediate window:
INSERT INTO tblA(STATUS,SCAC,VAN_TYPE,TCN,CONTAINER,BOOKING,PCFN,LOB_V,CONSIGNOR,CONSIGNEE,COMM_VOYDOC,VOYDOC,SAIL_DATE,POE,POD,VESSEL_STATUS,VESSEL_NAME,CARGO_DESC,METRIC,CUBE,LENGTH,WIDTH,HEIGHT,WEIGHT,MTON,COMMENT_ONE,COMMENT_TWO,TYPE,BB/CONTAINER,CREATE_DATE,STATUS_REASON,WORK_COMMENT,MAN_RCVD?,MAN_VALID?,HAS_VD?,SI_RECV,CARRIER_BKD?,CARRIER_HAS_SI?,IBS_STATUS,BRIGADE,BATTALION,MULTI-MODAL) VALUES ('Open','APLS','20 FT DRY','MX4002','USMU0144111','1112144','113815','1','MX4002','MMA900','SKN077','N2626','5/31/2014 12:00:00 PM','QA1','1Q1','VD','APL SOKHNA','REPAIR PARTS,VIC','NO','1360','240','96','102','17800','','MWY52R','','STANDARD','CONTAINER','5/31/2014 12:00:00 PM','','System Generated Open Status.','NO','NO','YES','4/20/2014 12:00:00 PM','YES','YES','MEASURED','595th','831st','NO');
From Immediate window:
INSERT INTO tblA(STATUS,SCAC,VAN_TYPE,TCN,CONTAINER,BOOKING,PCFN,LOB_V,CONSIGNOR,CONSIGNEE,COMM_VOYDOC,VOYDOC,SAIL_DATE,POE,POD,VESSEL_STATUS,VESSEL_NAME,CARGO_DESC,METRIC,CUBE,LENGTH,WIDTH,HEIGHT,WEIGHT,MTON,COMMENT_ONE,COMMENT_TWO,TYPE,BB/CONTAINER,CREATE_DATE,STATUS_REASON,WORK_COMMENT,MAN_RCVD?,MAN_VALID?,HAS_VD?,SI_RECV,CARRIER_BKD?,CARRIER_HAS_SI?,IBS_STATUS,BRIGADE,BATTALION,MULTI-MODAL) VALUES ('Open','APLS','20 FT DRY','MX4002','USMU0144111','1112144','113815','1','MX4002','MMA900','SKN077','N2626','5/31/2014 12:00:00 PM','QA1','1Q1','VD','APL SOKHNA','REPAIR PARTS,VIC','NO','1360','240','96','102','17800','','MWY52R','','STANDARD','CONTAINER','5/31/2014 12:00:00 PM','','System Generated Open Status.','NO','NO','YES','4/20/2014 12:00:00 PM','YES','YES','MEASURED','595th','831st','NO');
Last edited: