Reads MySQL into Excel sheet


Add to Cart
This is the driver and VBA macros needed to run MySQL queries inside Excel VBA code

May 2010
Internal ID:
77380 (type1)
1 File Tools
Quick tools. Tools that are in 1 file
VBA - Excel
Macros, or Visual Basic for Application tool
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