Powerful tool to Convert any Excel file to MySQL and vice versa with scheduling options , it can also store any Excel files in PHP script to import it to MySQL even when direct connection to the MySQL server isn't allowed
Version: 3.0Excel-MySQL converter is a powerful tool to convert any Excel file to a MySQL database or convert any MySQL database to an Excel file utilizing a very easy to use wizard style interface that support so many advanced options like (scheduling,command line support , table selection , field selection,..). The wizard can also store any Excel file into a php script to import it to MySQL even if remote connection to the MySQL server is not allowed .
License: Free To Try $38.00
Operating System: Windows
1)All versions of MS Excel are supported 2)Works with all versions of Unix and Windows MySQL servers 3)Supports both local and remote connections to MySQL server. 4)Ability to convert the Excel file into MySQL indirectly if you are not allowed to connect your Mysql server remotely 5)Support for scheduling conversion tasks to be performed automatically. Â· 6)The ability to select only the tables you want convert. 7)The ability to select only the columns you want to convert from each selected table . 8)You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database. 9)Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets 10) Command line support.
Version 3.0: Scheduling of the conversion tasks to be performed automatically.