MySQLReader Added: 10/13/2011 | Created: 5/3/2010
Read any MySQL query into Excel table + VBA Code
This uses VBMySQLDirect application to read data from MySQL database into Excel spreadsheet
To run this you just need to install this app first, then open Excel file.
The installed app will register the required dll into Excel VBE, you need to do nothing more than installing it.
The zip contains the worksheet that has the macro and the exe file that needed to install VBMySQLDirect
Project page: http://www.vbmysql.com/projects/vbmysqldirect
More information in this FreeVBCode post
Download (1.2 MB)
1300 downloads | Last updated: 1/15/2014