xls2mysql for windows : Excel Reader and Mysql converter [Webmaster Bulletin]

xls2mysql for windows : Excel Reader and Mysql converter

3 Responses to “xls2mysql for windows : Excel Reader and Mysql converter”
January 24, 2009 - H.Delesalle

Hi,

I understand that this script only displays the SQL statements that have then to be executed via a database admin interface.
Am I right ?

What about directly excuting this code into a MysSql database ?
This would be very useful to update regularly a database on a site from a xls file administrated locally on a desktop computer.

Thanks for clarifying.

Hervé.
January 24, 2009 - admin

Hi you’re right the script displays SQL AND creates a file : you could add a soft that applies the file though
July 28, 2010 - See World

PHPAdmin also can import xls