MySQLReader
Reads MySQL into Excel sheet
$25.00
This is the driver and VBA macros needed to run MySQL queries inside Excel VBA code
Published:
May 2010
Internal ID:
77380 (type1)
1 File Tools
Quick tools. Tools that are in 1 file
Quick tools. Tools that are in 1 file
VBA - Excel
Macros, or Visual Basic for Application tool
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: http://www.vbmysql.com/projects/vbmysqldirect
More information in this FreeVBCode post
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