hi friends,,,,,
hi friends can you say how to import ms excel data into mysql,,,,,,,,,using php queries only,,,,,
xls
Moderator: General Moderators
Re: xls
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 queriesmadu wrote:hi friends,,,,,
hi friends can you say how to import ms excel data into mysql,,,,,,,,,using php queries only,,,,,