Home » Forums » Open Source Learning Center » Question and Answer

VBA excel to communicate with external SQL database

Submitted by palu on 9 September, 2010 - 19:14

Hi there,

Curious if someone knows how to create

a VBA app that upon a click of a button can connect

to the database "MySQL", query it and return results.

Can this be done with ADO methods?

 

Sincerely,

 

Palu

‹ Random 3D6 Die-Roll and Test How to Run an operation based 7 conditions in same cell ›
»

ODBC Connection

Submitted by ffreitas on 6 January, 2011 - 03:37.

Hi palu,

It can be done using a ODBC connection to the MySQL database, you will still be using ADO and using regular recordsets. Let me look for a code I wrote some time ago and I will get back to you with the connection string.

Regards

 

FFreitas

»