ActiveX alternative for Excel 2004 vba

[scv109]

Hi All,

Definitely new to a Mac and am really confused as to how to use the ODBC functions... I have a macro that I am building to access a sql table, however I am not sure of the syntax to use....

This is where I am going wrong (I think)

Public strConnection As String
Public oCon As New ADODB.Connection
Public rsSec1 As New ADODB.Recordset
Public Counter As Double
Public StopCounter As Double
Public SQLFilter As String
Public SQL1 As String
Public strInput As String


Public Sub ServerCon()

Set oCon = New ADODB.Connection
Set rsSec1 = New ADODB.Recordset

strConnection = "PROVIDER=SQLOLEDB;DATA SOURCE=IRP_prod;user id=I*****;password=i****;"
oCon.ConnectionTimeout = 60
oCon.Open strConnection

End Sub

Can anyone convert this so I can use it on a Mac??