@kyle sorry i misread mssql as mysql however i think its the same situation.
i believe all you need is to change your provider string to connect to MSSql.
Set cnn = New ADODB.Connection
' Open a connection by referencing the ODBC driver.
cnn.ConnectionString = "driver={SQL Server};" & _
"server=;uid=;pwd=;database=
"
cnn.Open
thanks also