Convert Excel files to MySQL and vice versa using scheduling options with this powerful tool. Store Excel files in PHP script to import to MySQL, even if direct connection to the server is blocked.
The Excel-MySQL converter is an exceptional tool designed for those who need a powerful method to convert Excel files to a MySQL database or a MySQL database to an Excel file. The software comes with a wizard-style interface that is highly intuitive and makes the entire process of conversion hassle-free.
One of the key highlights of the Excel-MySQL converter is the advanced options it supports. These include scheduling, command line support, table selection, and field selection, among others. Besides that, the wizard can also store any Excel file into a PHP script to import it to MySQL, even if a remote connection to the MySQL server is not allowed.
Some of the essential features of the software include support for all versions of MS Excel, compatibility with all versions of Unix and Windows MySQL servers, local and remote connections to MySQL servers, and the ability to convert the Excel file into MySQL indirectly. The software also offers scheduling conversion tasks to be performed automatically and allows users to select only the tables they want to convert or the columns they want to convert from each selected table.
The conversion process gives users the options to either convert to a new database, overwrite an existing one, or append tables to an existing database. Moreover, the software enables splitting MySQL tables with more than 65535 records into multiple Excel spreadsheets, and it comes with command line support.
In summary, if you are looking for an efficient and effective way to convert Excel files to a MySQL database or vice versa, the Excel-MySQL converter is the perfect tool for the job. It offers exceptional features and an easy-to-use wizard-style interface that makes the entire process seamless.
One of the key highlights of the Excel-MySQL converter is the advanced options it supports. These include scheduling, command line support, table selection, and field selection, among others. Besides that, the wizard can also store any Excel file into a PHP script to import it to MySQL, even if a remote connection to the MySQL server is not allowed.
Some of the essential features of the software include support for all versions of MS Excel, compatibility with all versions of Unix and Windows MySQL servers, local and remote connections to MySQL servers, and the ability to convert the Excel file into MySQL indirectly. The software also offers scheduling conversion tasks to be performed automatically and allows users to select only the tables they want to convert or the columns they want to convert from each selected table.
The conversion process gives users the options to either convert to a new database, overwrite an existing one, or append tables to an existing database. Moreover, the software enables splitting MySQL tables with more than 65535 records into multiple Excel spreadsheets, and it comes with command line support.
In summary, if you are looking for an efficient and effective way to convert Excel files to a MySQL database or vice versa, the Excel-MySQL converter is the perfect tool for the job. It offers exceptional features and an easy-to-use wizard-style interface that makes the entire process seamless.
What's New
Version 3.0: Scheduling of the conversion tasks to be performed automatically.