Harvinder, Are these valid dates? Some clearly aren't ( "0"). I can think of at least two ways to get this loaded: 1. Use a column expression (http://tinyurl.com/29k93m) within your Sqlloader control file to convert the data into a valid date. 2. Load the data into a staging table that has this column defined as a VARCHAR2. Then write a PL/SQL procedure that moves the data from the staging table to the real table. The procedure should include the necessary logic to convert this column into a recognized Oracle date format. On 10/3/07, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote: > > Hi, > > We have a flat file that contains a column and the values are stored as: > 991123 > 421 > 60823 > 0 > 70930 > > Now we are moving data from flat file to table and this column will be > inserted into Date dataype column, What is the way to insert into this > table and avoid "ORA-01821: date format not recognized" errors. > > Thanks > --Harvinder > > -- > //www.freelists.org/webpage/oracle-l > > > -- Rumpi Gravenstein