Thiago Souza Thiago Souza - 10 months ago 263
MySQL Question

Mysql error 1136 Excel

I've been trying to export a table from excel to MySQL using the MySQL for Excel extension but I'm getting this error:

Mysql error 1136: Column count doesn't match value count at row 1 Excel

My table has 21887 rows and 23 columns.

MySQL Workbench is opened and the database is connected.

This is the Excel export data screen and the settings:

Error ocurred

And this error occurs during the exporting:

MySQL Excel plugin

Answer Source

Excel was using the comma symbol to separate decimal numbers and the MySQL Workbench was interpreting as two numbers, bacause of this the column count wasn't matching.

So I solved this casting the decimal numbers to string.