MySQL Forums
Forum List  »  MySQL for Excel

Re: Excel to EDIT BD MySQL
Posted by: Javier Treviño
Date: December 07, 2012 03:37PM

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

Options: ReplyQuote

Written By
November 16, 2012 04:59AM
Re: Excel to EDIT BD MySQL
December 07, 2012 03:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.