Unanswered: Connection Between VBA excel and mysql
Hello, I am a newbie to access Mysql using VBA for excel. How can I access a mysql 4.1 using VBA code ? Whar do i have to do? I just know that i have to install a ODBC driver but how can i do this ?? Please help-me.
Just remember that you will check the ado in the reference library in the vb editor to use the ado objects. Depending on what you are using the data for you may have to create a procedure to write data to the cells in the spreadsheet.