importng data

[robert davies]

i have the query

LOAD DATA
INFILE 'C:/web/registers/23-03-2005.txt'
INTO TABLE attendance
FIELDS TERMINATED BY ';'
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '|'
;

it seems to work only when there is one record in the file(23-03-2005.txt) when i add more than one record it says there is an error

1062 duplicate entry '0-0' for key 1

theres no duplicate records in the import file i think it might have somthing to do with the table attendance having a joint primary key the first and second fields ie the data in the file looks like

1001;200147737;(a date); present; (atimestamp);

that works

1001;200147737;(a date); present; (atimestamp);
1001;200123213;(a date); present; (atimestamp);

this does not

any ideas?