xls2mysql for windows : Excel Reader and Mysql converter

xls2mysql-screenshot11xls2mysql 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 !

 

downloadTRY 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


SCREENSHOT

 

 

  1. 2 Responses to “xls2mysql for windows : Excel Reader and Mysql converter”

  2. 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

  3. 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

Post a Comment