Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|