Can an Excel Workbook call an online database?

[Michael Island]

I have an Excel Sheet that has MySQL Selects, Updates and Inserts. I want to run them from here to save time.
I have an online MySQL database hosted by TSO hosting.The Queries need to be able to get a result,
either the result of the SELECT or a confirmation that the UPDATE or INSERT was successful.

[Michael Island]

I found this if any use:

CODE/

Sub test()

Dim cn As Connection
Dim rs As Recordset

Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI11;Password=myPassword;User ID=[username]@[servername];" & _
"Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;"
cn.Open

Set rs = New Recordset
rs.Open "SELECT Top 1 * FROM [SomeTable]", cn, adOpenStatic, adLockReadOnly

ActiveSheet.Range("a1").CopyFromRecordset rs

End Sub

/CODE