ANmarS - Portfolio - MySQLReader

Excel/VBA expert since Sep 1997 (19 years 11 months)

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:

More information in this FreeVBCode post

Download (1.2 MB)

1315 downloads | Last updated: 1/15/2014

Screen shots (6)