Good day !
We have MySQL database where we update our data. Basically it is product database.
But we also need to import data from there to Excel.
I have used csv import so far and it works ok, but have some problems..
With that Excel sheet we like to color code some rows. ie. we look matching product to our buyer and want to color code good ones with green and bad ones with red and so on...
But always when updating for fresh data color codes get mixed up...
Any ideas/workaround to keep color coding ?
(i have tried also direct connect to our mysql server but no luck.. and it doesn't help when mysql for excel plugin is totally unreadable in 4k view)
thnks in advance !
We have MySQL database where we update our data. Basically it is product database.
But we also need to import data from there to Excel.
I have used csv import so far and it works ok, but have some problems..
With that Excel sheet we like to color code some rows. ie. we look matching product to our buyer and want to color code good ones with green and bad ones with red and so on...
But always when updating for fresh data color codes get mixed up...
Any ideas/workaround to keep color coding ?
(i have tried also direct connect to our mysql server but no luck.. and it doesn't help when mysql for excel plugin is totally unreadable in 4k view)
thnks in advance !