SQLLDR

[ErikButler]

I am needing to load data from a flat file into a table

the data example is
610,1/7/1991 0:00:00,101,1/8/1991 0:00:00,101.40

here is my control file but it rejects every line of the input file

Control:

load data
infile 'i:\SALES_ORDER.txt'
insert
into table sales_order
fields terminated by ","
(
order_id,
order_date DATE 'mm/dd/yyyy' ,
customer_id,
ship_date DATE 'mm/dd/yyyy',
total
)

Please advise as to where i have hosed this thing up


Thanks
Erik

Thanks
Erik Butler
2000 MCSE
erikbutler@centurytel.net

 

[LKBrwnDBA]

See if this works:

...
order_date DATE 'mm/dd/yyyy hh24:mi:ss' ,
customer_id,
ship_date DATE 'mm/dd/yyyy hh24:mi:ss',
...

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ddrillich]

I use double quotes around the date format. I'm not sure whether the single quotes and double ones are interchangeable here.

Cheers,
Dan

 

[ErikButler]

thanks that work great.

I didn have another problem with a foreign key still enabled but everyting is working now. thanks

Thanks
Erik Butler
2000 MCSE
erikbutler@centurytel.net