Re: Append function no longer works on a table

[Javier Treviño]

Hi John,
Thanks for writing in our forums!

There is no limit on table size or data in the append function of MySQL for Excel, but judging by the error message you are getting it sounds like a query timeout is happening in the underlying database connection layer.

Does the table have update triggers that could be causing the data update to take a considerable amount of time? Can you give more information about the number of rows you are trying to append for example?

Do you see any additional information that could be useful to trace the source of the timeout in the MySQL for Excel log (contained in %APPDATA%\Oracle\MySQL for Excel) or in the MySQL Server log?

Best Regards.

====================================
Javier Treviño
MySQL on Windows Team