HI,

I want to read record from a DBF file (dBase IV) and add this record
to a table in access (MDB). How can i do it? As soon as I tried to
open the DBF file a got this error message-> Invalid Path.
But the path is good.

I tried many thing, but did't make it work.

Here is a code that a tried:

Dim dbs as Database
Dim rst as Recordset

Set dbs = OpenDatabase("ENTBX.DBF", False, True, "dBase IV;C:\DBPATH")
Set rst = dbs.openrecordset

Could somebody help me with this?
Thank's

Nic

Here's one I did earlier...... Obviously you'll need to change the table
names..

    Set tb = db.CreateTableDef("drg_main")
    tb.Connect = "dBase III;HDR=NO;IMEX=2;DATABASE=" & strPath
    tb.SourceTableName = "drg_main.dbf"
    db.TableDefs.Append tb

This way does work - you can then refernce the tabledef with a recordset
object as normal.

Cheers,

Davy