Run Query in Excel 2010 AND 2013 on remote MySQL db
Posted on 2014-08-01
ok, so i have a script that creates two tables in memory then populates those tables with a few items from other tables. Those two tables are then merged into one and the output is downloaded to csv then opened and saved to excel. Of course when i close the tool the two tables are removed from memory.
essentially it's a script I run at the end of every month to pull commission data for accounting/sales. I run this script in the MySQL Workbench>Query tool directly on the server. I then email that file to the payable clerk.
I was wondering if there was a way i could have this script run from within Excel on the clerk's computer (read only of course) so they can push a button and have the data instead of waiting for me to do it on the server.