速報APP / 工具 / Excel2MySQL

Excel2MySQL

價格:免費

更新日期:2014-03-04

檔案大小:6.8 MB

目前版本:1.3.11

版本需求:OS X 10.6.6 或以上版本

Excel2MySQL(圖1)-速報App

Originally, Excel2MySQL was created to increase the speed of multi-million record analysis within ChartPoint. See: https://itunes.apple.com/us/app/chartpoint/id646915789?mt=12

Excel2MySQL(圖2)-速報App

With the ease of drag&drop simplicity you can upload millions of records from multiple Excel or CSV files to your MySQL database with amazing speed. Simply drag and drop your files over the application window; press Next, then Finish. Three simple steps and your files will be indexed and stored as individual tables within your MySQL database.

Excel2MySQL(圖3)-速報App

Excel2MySQL adds a great deal of intelligence to automated database management. If you have an excel file which updates on a frequent basis, you can drag the entire file into this application and select the option to remove duplicates. This will allow you to only update the MySQL table with the latest data and not worry about cleaning the previously uploaded records. Similarly, it allows you to drag multiple versions of the same file from different dates without having to worry about possible overlaps.

Excel2MySQL(圖4)-速報App

Finally, for those of you who would like to add columns to your database in the form of calculations or other logic, simply add them behind the columns. You can then interact with the database via PHP or other languages. Excel2MySQL will import its columns as expected while allowing for future flexibility and database dynamics.

Excel2MySQL(圖5)-速報App

You can also export databases to CSV or multi-sheet or single-sheet Excel files.

If there are features you would like to see in future versions of this application, please let us know!