Excel ODBCDIRECT

  • Thread starter Thread starter LarryC
  • Start date Start date
L

LarryC

I want to update an oracle database from excel using
ODBCDirect. The VBA help has an example subroutine
Preparex.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sub PrepareX()

Dim wrkODBC As Workspace
Dim conPubs As Connection
Dim qdfTemp As QueryDef
Dim rstTemp As Recordset
' Create ODBCDirect Workspace object and open
Connection
' object.
Set wrkODBC = CreateWorkspace("", _
"admin", "", dbUseODBC)

......
End Sub
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
When I execute the example, I receive an error referring
to: Dim wrkODBC As Workspace
Compile error:
User-defined type not defined

Seems like there is a missing library that defines
Workspace etc...

Does anyone have any ideas?

Thanks.
 
Back
Top