How do I update a MySQL table with user data using excel formulas

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
kkevsta
Posts: 1
Joined: Tue 05 Jun 2018 12:56

How do I update a MySQL table with user data using excel formulas

Post by kkevsta » Tue 05 Jun 2018 13:08

Hi,

I have a MySQL table that must be updated using a spreadsheet with formulas. I have set up two tables, one for the database data and one for the user data (directly below the database table). The formulas in the database table reference the user data table, where all changes are made.

When I change the user data the database table changes accordingly, and the colors change to show the altered fields but the Commit button remains greyed out.

Can anyone tell me what I am doing wrong? Thanks.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: How do I update a MySQL table with user data using excel formulas

Post by Pinturiccio » Wed 06 Jun 2018 13:32

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Post Reply