Excel ODBCDIRECT

[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.

 

[Dick Kusleika]

Larry

Microsoft DAO 3.x Object Library

might be what you're looking for.