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
