Errcode: 2 when running LOAD DATA LOCAL INFILE on server

Hi. This is the script I write to upload a .csv file into my online mysql database : $sql_query="LOAD DATA LOCAL INFILE '$textfile' INTO TABLE purchase FIELDS TERMINATED BY ',' (purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)"; $sql_query=($sql_query);

How to add an excel file directly to MySQL database using PHP?

How can I add an excel file with *.xls extension directly into MySQL database..is it possible to do or I need to convert it into *.csv format or *.txt format first? Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ --