Re: Excel to MySQL

[richard briggs]

Many thanks for the info.

To tackle this then I have added a new section into the XML flavours file for each database type. Additional replace strings can be aded if desired.
Here is the MySQL section:

<ReplaceStrings>
    <Replace>
     <from><![CDATA[']]></from>
     <to><![CDATA['']]></to>
    </Replace>
</ReplaceStrings>

There is an interim new version 1.0.58 that includes these changes for MySQL has been posted here.

Mean while back to the work bench for testing with MySQL stored procedures later this evening.. !

I have also created a MySQL testing/feedback section here.

Many thanks so far.. :)



Edited 1 time(s). Last edit at 06/12/2012 06:10AM by richard briggs.