We are trialing the excel add-on to connect to MySQL database (Godaddy website). I must say the ease of setup was perfect! I was able to get the excel workbook to connect to the database and get the table from this database – but the error message has started to appear – at random time periods (sometimes no message in hour then it shows all the time):
Code: Select all
Commands out of sync; You can't run this command now
Code: Select all
Default FetchAll: True
One minor question – maybe we can just reopen the workbook – enable Edit mode and just commit as that – without needing to get the data each time before enabling Edit mode and committing?
Dave