hi HaidarPesebe,
one way to do this is : 1. save the excel to xxx.csv 2. then use the mysql SQL statement "LOAD DATA INFILE" for example : LOAD DATA INFILE 'c:\\test\\xxx.csv' INTO TABLE tbl_name FIELDS TERMINATED BY ',' best regards liuyann > From: haidarpes...@gmail.com > To: mysql@lists.mysql.com > Subject: from excel to the mySQL > Date: Tue, 3 Aug 2010 16:23:22 +0700 > > Dear All, > I'm needs a way to upload data from excel to the mySQL database. Dear all, I > need help is how to upload data from excel columns and load into mysql > database using php? > Thanks > HaidarPesebe