Thiago Souza Thiago Souza - 14 days ago 13
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

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.

Comments