Topic: Access + MySQL

Good afternoon!
I ask the help in
There is a connection
On Error Resume Next
Dim oConn As Object
Set oConn = New ADODB.Connection
oConn. Open "DRIVER = {MySQL ODBC 5.3 ANSI Driver};" AND _
"SERVER=test;" AND _
"DATABASE=test;" AND _
"UID=test;" AND _
"PASSWORD=test;" AND _
"PORT:3306;" AND _
If oConn. State = adStateOpen Then
MsgBox "Zdrasti, I your Aunt smile"
MsgBox "Figase... = ("
End If
Further it is necessary to pull out the data from what  tables, help to write an example...
And still a question, on each event I should open connection (is written above) if it is necessary to pull out the data???


Re: Access + MySQL

And for example to place in sheet boxing