Using WinMySQL Professional

Load data from a delimited file

Only accessible when connected and when a table is active, the «Table management>Load data from a delimited file» submenu is a feature appeared with release 1.05 of WinMySQL Professional which gives the possibility to pump local data from a delimited file to put it into a MySQL® table having at least all the columns of the delimited file.

The delimited file structure is very simple : the first line describes the column names (separated by a delimiter of your choice. Semicolon is the default for WinMySQL Professional, Microsoft® Excel®, Microsoft® Access® ...) in which, WinMySQL Professional, will send data. The other lines, consisting in values separated by the delimiter, describes the content of each cell. It is important that the last lines is terminated by a carriage return and a line feed.

At the opposite of a data loading with the submenu «Table management> Load data from dBaseIII+®», loading data from a delimited file doesn't require exactly the same structure between the local file and the MySQL® remote table : indeed, WinMySQL Professional only looks the column names to insert data. If an error happens during insertion, the user will be asked to skip and continue insertions or abort it. Remember that MySQL® doesn't support transactions yet, so all already inserted lines won't be canceled when a trouble occurs.

Note : If you want to import date values, it must be formated as following : yyyy-mm-dd.

This feature may seem crazy, but in fact, it allows to obtain data (manual enter, obtained data after office automation processing, etc ...) with most of major office automation softwares such as Microsoft® Excel®, Microsoft® Access® or Sunsoft Staroffice, and then export the data to the delimited standard (*.csv) to import it thru WinMySQL Professional.

To do that, simply click on the «Table management>Load data from a delimited file» submenu, choose your delimiter, check the data imported in the grid and confirm upload when WinMySQL Professional asks for it.