Using MySQL for Excel in France
Hi,
Tonight I was so happy to discover that this tools exists, however it looks like there is a bug on French systems which disapoints me a lots... as you may know in France, all the floating numbers are written like : 12,45€ instead of 12.45€
This gives the following querry when I try to commit an entry :
Deleting 0, Inserting 1, Updating 0 row(s) with the following SQL statement(s):
001: INSERT INTO `world`.`country` (`Code`,`Name`,`Continent`,`Region`,`SurfaceArea`,`IndepYear`,`Population`,`LifeExpectancy`,`GNP`,`GNPOld`) VALUES ('TK','Tans','Africa','Eastern Africa',390757,1980,11669000,37,8,5951,8670)
MySQL Error 1136:
Column count doesn't match value count at row 1
The value 37,8 is considered as 2 different colums instead of one single number. Does anybody know a workaround?