VBA: Paradox import

[Emperor]

Hi all,

I am trying to import an Paradox database into Excel but I can't get it to work. My code did function for an Access database and it should be easy to change this to a paradox (*.db) database.

Code for Access-database:

Dim DB As DAO.Database
Dim Tbl As DAO.TableDef
Dim Fld As DAO.Field
Dim ws
Set ws = Worksheets("settings")
 
Dim DBString
DBString = ws.Range("G2").Value
 
Set DB = DAO.OpenDatabase(DBString)

What I have found is that in 'DAO.OpenDatabase' the connection is a setting which can be set to "Paradox 5.x"
But when I set it; e.q.
Set DB = OpenDatabase(DBString, False, True, "Paradox 5.x")
XL says that the path is incorrect.

Path in settings (G2) is : C:\Temp\database.DB

Any help is welcome!

Mathijs.