Export MySQL to Excel or import Wxcel to MySQL using this tool
Excel-MySQL is an automation software that can convert any MySql database into MS Excel spreadsheets or convert any Microsoft Excel spreadsheets into MySQL database , utilizing easy to use Wizard style interface, Just follow the simple screens and let the.. Along with general functionality - data importing / exporting- the wizard allows you to store your data to PHP script to be able to import your Excel file to MySQL even if remote connection to the target MySQL server is not allowed. Here are some key features of "Excel to MySQL converter":
· All versions of MS Excel are supported
· Works with all versions of Unix and Windows MySQL servers
· Supports both local and remote connections to MySQL server.
· Support for scheduling conversion tasks to be performed automatically. ?·
· The ability to select only the tables you want convert.
· The ability to select only the columns you want to convert from each selected table .
· You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database.
· Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets
· Command line support.
· The Demo version of Excel-Mysql Converter allows you to convert only the first three tables for any database and only the first five records for each table. What's New in This Release: [ read full changelog ]
· Scheduling of the conversion tasks to be performed automatically.