Re: Excel to EDIT BD MySQL

[Javier Treviño]

Hi,
Thanks for posting in our forums.

MySQL for Excel is designed to exit "Editing Mode" when the worksheet is closed, think of it like a "Editing Session" where all mappings between the worksheet cells and the MySQL table's rows and columns are maintained, so when closing the worksheet the "session" ends. However the connection to the DB is not closed so even though you closed that worksheet you can work with another worksheet as long as the MySQL for Excel Add-In is still open.

When you say that you cannot use the "same sheet to edit MySQL DB" do you mean that you saved the worksheet contents into a file so you close it and open the file again?

If that is the case when you open the saved file again the contents of the file are actually placed in a new worksheet, so it is not the "same sheeet". Given that nature of how Excel works closing the worksheet closes your editing session so you have to "open" a new editing session again in a new sheet, since you can't edit a MySQL table's data in an existing worksheet.

Hope this answers your question, if not please reply back with any more comments.

Best Regards.

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