Excel and MySQL

[dbarelli]

Hi everyone, I'm trying to connect an excel worksheet with a MySQL Database. I already know how to connect to an Access but now I have to change the database.
I will thank you all if someone could give me a short example (or a link to one) about connecting to MySQL and retrieve information.

Regards.
Daniel.

[Leith Ross]

Hello Daniel,

This link should provide you with all the information you need about choosing the correct connection string for your application of MySQL.

http://www.connectionstrings.com/?carrier=mysql

Here is another link for connection information to various database servers, files, etc.

http://www.connectionstrings.com/

Sincerely,
Leith Ross

[dbarelli]

Leith, many thanks for the links. But actually I'm looking for a complete example, nothing so extensive, just a few lines with the connection code because I cannot solve how to do it.

Many thanks to all.
Daniel.

[hitea]

Here is working code I use. Just insert your specific data where I have (#ENTER_????#)

With Selection.QueryTable
.Connection = Array(Array( _
"ODBC;DSN=#ENTER_DSN#;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=#ENTER_DATABASE_NAME#;SERVER=#ENTER SERVER URL OR IP#;UID=#ENTER USERNAME#;PASSWORD=#ENTER PASSWORD#;PORT=3306;OPTIO" _
), Array("N=3;STMT=;"))
.Sql = Array(#ENTER NAME OF STRING CONTAINING QUERY STATEMENT#)
.Refresh False
End With

Enjoy!