DB Connection error
 

Hi,
I am using one of the tips to pull data from the excell sheet into an
access table (acutually multiple tables) However, I keep getting an
error from by openDatabase command. Any Ideas?
Here is the Code:

Dim wk As Workspace
Dim dbConn As Database
Dim rs As Recordset
Dim r As Long
Dim iCID() As Integer
Dim iCT() As Integer
' Can also use system dns "tfTestDB", but it does not work either
Set wk = CreateWorkspace("", "admin", "")

----Problem code vvvvv
Set dbConn = wk.OpenDatabase("C:\Documents and Settings\Josh Peltier\My
Documents\TerraFirma\db\test\testData.mdb"

Any help would be great.

Josh


---
Message posted from http://www.ExcelForum.com/