SQL help

Have this table +------------+---------------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+------------+----------------+ | id | tinyint(3) unsigned | | PRI | NULL | auto_increment | | month | date | | | 0000-00-00 | | | company | varchar(30) | | | 0 | | | title | varchar(75) | YES | | 0 | | | actor_name | varchar(20) | YES | | NULL | | | actor_role | varchar(75) | YES | | NULL | | +------------+---------------------+------+-----+------------+----------------+ using this query: LOAD DATA LOCAL INFILE "data.txt" INTO TABLE table (month,company,title,actor_name,actor_role); data.txt looks like: 2002-02-01;Coastal;Prospecting;Zoe Whitaker;Corporate Representative 2002-02-01;Commercial;Barton Ford;Dave Hobbs;Car Salesman 2002-02-01;Commercial;Barton Ford;Jackie Jackson;Customer's Wife 2002-02-01;Metro Video;"Right Spirit Campaign (Binge Drinking PSA), - Richmond, VA";Amie Hill;Spokesperson 2002-02-01;Metro Video;"Right Spirit Campaign (Binge Drinking PSA), - Richmond, VA";Tom Downs;Jim (Sailor)/Principal 2002-02-01;Metro Video;Colonial Williamsburg;Molly Larkin;Mother/Wife etc... I end up with a bunch of rows like this and teh data does not get imported: 0000-00-00;;;; Tried via MySQL front, phpmyadmin and directly via mysql al with same results.