SInce the Jet 4.0 version doesn't support any more the "Foxpro" drivers ...

How can you link or Insert a Foxpro table (dbf), in a Access file (2000) ??

Here is the sample i use to Insert a DBase Table in Access :

_____________________________________

Set oConnMDB = New ADODB.Connection

oConnMDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\MyFile.mdb"

StrSQL = _
"SELECT * INTO " & _
"[C:\MyFile.mdb].[NewTableName] " & _
"FROM " & _
"[dBase IV;database=C:\MyDBFPath].[MyDBFTableName] "

oConnMDB.Execute StrSQL
______________________________________

What is the technic for a FoxPro File ?? Knowing that :

- I connect to an Access File like this:

oConnMDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\MyFile.mdb"


- and I connect to an Foxpro File like this ?

oConn.Open & _
"Driver={Microsoft FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=C:\FoxproDBFFolder;" & _
"Exclusive=No;"


-> So the SQL execution string can not work ...

I'm new in ADO ... If you have any code sample, or any help, where to start
? Thank's to any one ...

Driss.