[SOLVED]Excel, VBA to MySQL?

[Chrissy]

I use an Oracle database and this is how I connect to our DB (except I use Msdaora for my provider)... maybe if you do some changing around it will work for you.

Dim Conn As ADODB.Connection
Dim rsRec As ADODB.Recordset
 
Set Conn = New Connection
 
Conn.ConnectionString="Provider=MySQLProv;Database=astramedia;Uid=root;Pwd=Password;"
Conn.Open
 
Set rsRec = New ADODB.Recordset
rsRec.CursorType = adOpenKeyset
rsRec.LockType = adLockOptimistic
rsRec.ActiveConnection = Conn