I have a MySQL database and have a lot of users that want to use Excel to process this data. I know how to do two things that I don't want:
- I know how to import a MySQL database into Excel.
- I know how to "open" a table via ODBC from Excel and this table is now refreshable.
The second thing is close to what I want, but I would like all the tables to be in an Excel file (probably each table in a different tab). Is there a way to do this?
Bonus points if someone can tell me how to make a custom select query for a tab.