ADO/VBA
 

I am trying to interface to export Excel data into Oracle direclty. In
attempting this I keep gettig errors. The lines below with an asterix are
the problem lines.

Dim rs As New ADODB.Recordset
Dim cn As New ADODB.Connection
* Set cn = ADODB.OpenConnection
* cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;"

At Set I get "Invalid Outside Procedure". If I remove the line containing
Set, I get the same error at cn.Open. Any suggestions? Could it be my
references? Any help would be greatly appreciated!!

Brent