I'm trying to import an excel file into a table. The excel file has dates in the following format: 20/08/2008 12:00:00 AM
and I am telling SQLDEV the following: DD/MM/YYYY H24:MI:SS AM
To import the file, I am right clicking on the table in SQL Developer, hitting import data and then selecting the file, I map the columns and set the format to above and get the above error. Here's the table:
--------------------------------------------------------
-- DDL for Table DRUG_INFO_NOS
--------------------------------------------------------
CREATE TABLE "DANIEL"."DRUG_INFO_NOS"
( "DIN" VARCHAR2(20 BYTE),
"TRADE_NAME" VARCHAR2(50 BYTE),
"FORM" VARCHAR2(40 BYTE),
"GENERIC_NAME" VARCHAR2(60 BYTE),
"MANUFACTURER" VARCHAR2(100 BYTE),
"CR_DATE" DATE,
"NOC_DATE" DATE,
"FIRST_CLAIM_DATE" DATE,
"SEQUENTIAL_ID" NUMBER
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "DATAL03" ;
--------------------------------------------------------
-- Constraints for Table DRUG_INFO_NOS
--------------------------------------------------------
ALTER TABLE "DANIEL"."DRUG_INFO_NOS" MODIFY ("DIN" NOT NULL ENABLE);
ALTER TABLE "DANIEL"."DRUG_INFO_NOS" MODIFY ("TRADE_NAME" NOT NULL ENABLE);
ALTER TABLE "DANIEL"."DRUG_INFO_NOS" MODIFY ("GENERIC_NAME" NOT NULL ENABLE);
ALTER TABLE "DANIEL"."DRUG_INFO_NOS" MODIFY ("MANUFACTURER" NOT NULL ENABLE);
ALTER TABLE "DANIEL"."DRUG_INFO_NOS" MODIFY ("SEQUENTIAL_ID" NOT NULL ENABLE);
but I am getting the above error. What's up?