Downloads
- March 18, 2009
xls2mysql for windows : Excel Reader and Mysql converter
xls2mysql is a  standalone application for Windows XP / Vista  that creates SQL queries from Excel data,  including table create statement, using columns names  from cell values in the first row.
- Xls2mysql improves your productivity by automatically converting Excel records to SQL insert queries ready for mysql.Â
- Xls2Mysql  saves precious time for real work on your dynamic  websites or mysql powered application :
- Multi sheet enabled Excel reader :
- Loads and preview excel fil,
- Parses unlimited amount of Excel sheets per file
- Excel Sheet selector,
- Displays records for selected sheet
- Mysql statement builder :
- sanitize file name for table name
- builds SQL create table statement out of first row (sanitize column names, create coln name if string is empty)
- builds sql insert statements out of rows 1..N
- converts date type columns to mysql standard YYYYMMDD format
- creates SQL file for MysqlÂ
You can also convert your Access databases to Mysql using xls2mysql :
Export your Access tables to Excel files and process them through xls2mysql !
Â
TRY BEFORE YOU BUY : xls2mysql FREE trial version (40 rows limit)
Click here to download xls2mysqlTrial
>> BUY Â UNLIMITED VERSION (19$ download)
AVAILABLE FOR WINDOWS XP & VISTA – click here to purchase
we are glad to offer 30 day money back guarantee if your are not satisfied
INSTRUCTIONS
- After purchase, use your user to access our download zone
- download the file and rename it to xls2mysql.exe
- if you had installed the trial version, uninstall it (go to your program files folder / xls2mysql and click wduninst)
- launch the installer and run !
- Browse your Excel File, off you go : it automatically read and converted to sql insert queries.
- any queries, problem, please contact us by email at webxadmin(at)free(dot)fr
Â
Â





2 Responses to “xls2mysql for windows : Excel Reader and Mysql converter”
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é.
By H.Delesalle on Jan 24, 2009
Hi you’re right the script displays SQL AND creates a file : you could add a soft that applies the file though
By admin on Jan 24, 2009