MySQL Forums
Forum List  »  MySQL for Excel

Update rows in MySQL with data from filtered rows in Excel?
Posted by: bob smith
Date: May 27, 2016 05:06PM

Microsoft OS: Windows 7
Excel Version: 2010
MySQL for Excel Version: 1.3.6

Requirement:

1. Use Excel filters while in edit mode of "Edit MySQL Data" function of MySQL for Excel.
2. Update existing rows in MySQL table with data from filtered rows only in Excel.

Tomfoolery:

1. Unprotect spreadsheet using VBScript script while still in edit mode of "Edit MySQL Data" function of MySQL for Excel.
2. Filter Excel worksheet, modify data in filtered rows.
3. Color of cells containing modified data doesn't change.
4. Cannot update MySQL table with data from filtered rows in unprotected spreadsheet.

Question:

Is there a way to update rows in a MySQL table with data from filtered rows in Excel using the "Edit MySQL Data" function of MySQL for Excel?

Options: ReplyQuote


Subject
Views
Written By
Posted
Update rows in MySQL with data from filtered rows in Excel?
1937
May 27, 2016 05:06PM


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.