Uploading to mySql Database

Dear friends,

I am unable to upload data from a text file to a mysql database using the LOAD DATA INFILE.... sql query in Java.

The following is the code snippet.

/***************/

query = "LOAD DATA INFILE C:\\TestParse1.txt INTO TABLE excelData FIELDS TERMINATED BY ,";

System.out.println(query);

Statement newStmt = con.createStatement();

res2 = newStmt.executeUpdate(query);

/*************/

Could anybody help me out in this? It is showing a message as output which says that there's some error in my SQL syntax.

Subhash

[595 byte] By [subhashmedhia] at [2007-11-27 10:42:12]