Can't load CSV file into Mysql Table using "LOAD Data"

Dear all i had posted this question to mysql@list, but got no reponse, therefore i think this group might help! I had made a TXT file from XLS, the field is seperate by comma, there are 4 fields in mysql table (hkd_rate), then i tried this command on mysql: "LOAD DATA LOCAL INFILE 'c:\hkd_rate.txt' into table hkd_deposit field seperated by "," " then my GUI mysql client program shows that the command had execute successfully, but when i type the " select * from hkd_deposit", it says it return no record. which i believe the data from the hkd_rate.txt did not load into the table. Could anyone pls help me why this is happening?