Using WinMySQL Professional

Load data from dBaseIII+®

Only accessible when connected and when a table is active, the «Table management>Load data from dBaseIII+®» submenu gives the possibility to pump local data from a dBaseIII+® file to put it into a MySQL® table having the same virtual structure.

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 dBase standard to import it thru WinMySQL Professional.

To do that, simply click on the «Table management>Load data from dBaseIII+®» submenu and confirm upload when WinMySQL Professional asks for it.

Of course, this procedure will abort if the local table and the remote table is incompatible. The best way to have compatible tables is to generate the MySQL® tables with dBaseIII+® files as templates using the «File>New MySQL® table from dBaseIII+®» submenu.

This procedure also aborts when an error happens (insertion of a duplicate primary key, not enough privileges, etc ...). MySQL® doesn't support transactions yet, so all already inserted lines won't be canceled when a trouble occurs.

Note : Because dBaseIII+® is an old data format which isn't Y2K compliant, WinMySQL Professional can't know if the dBaseIII+® dates handled come from the 1900's or the 2000's. Then it assumes it is 1900's. So, once imported, if you wish to modify to 2000's, you may use the pseudo SQL terminal («Submenu Open>SQL query (Menu File)» to submit the following query :

update your_table

set your_date_column=date_add(your_date_column, INTERVAL 36524 DAY)

where your_date_column<'2000-01-01'

(To perform this query, your MySQL® server must be 3.22.x and above)