Page 1 of 1

xls

Posted: Wed Dec 29, 2010 5:34 am
by madu
hi friends,,,,,
hi friends can you say how to import ms excel data into mysql,,,,,,,,,using php queries only,,,,,

Re: xls

Posted: Wed Dec 29, 2010 6:48 am
by Darhazer
madu wrote:hi friends,,,,,
hi friends can you say how to import ms excel data into mysql,,,,,,,,,using php queries only,,,,,
Use the PHPExcel library. The easiest way is if you save excel file as csv (with PHPExcel) and then you can either use LOAD DATA INFILE (if the database server is on the same machine) or use fgetcsv PHP function and create SQL queries