vba and MySql

[nd0911]

Hello,

is it possible to query (select) a mySql database (WordPress) with VBA ? and if so, how ? do I need to install some driver or somthing else ?

Thanks !

 

[nd0911]

Anybody....?

 

[Kyle123]

Yes, and yes, you need a connector. See here:https://support.office.com/en-us/ar...er-Query-8760c647-88b9-409d-b312-6ea8f84a269b

 

[nd0911]

Thank you but I want VBA and not power query.

 

[Kyle123]

The only thing that changed from any other connection is the connection string once you have the connector installed. You’ve use ADO in VBA before right?

As an aside, power query may actually be easier than VBA due the abominable ways Wordpress stores data!

 

[nd0911]

Yes I have used ADO on Access.

is this connection string ok ? because i get an error - that Data source name not found and no default driver specified.

    Set Cn = CreateObject("ADODB.Connection")
    Cn.Open "Driver={MySQL ODBC 3.51 Unicode Driver};" _
            & "Server=" & Server_Name & ";" _
            & "Database=" & Database_Name & ";" _
            & "Uid=" & User_ID & ";" _
            & "Pwd=" & Password & ";"