you can use 3 options, below are examples:

oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBC;" & _
"SourceDB=c:\somepath\mySourceDb.dbc;" & _
"Exclusive=No;"

Without a database container (Free Table Directory):

oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=c:\somepath\mySourceDbFolder;" & _
"Exclusive=No;"

OLE DB Provider for Visual FoxPro

oConn.Open "Provider=vfpoledb;" & _
"Data Source=.\MyDB.dbc;"


for more detail see http://www.able-consulting.com/ADO_Conn.htm

Good luck

Winan