I am building a project that must connect to both Foxpro and Oracle tables. I don't have a problem connecting to the Oracle tables but have not figured out how to create a recordset to the Foxpro. I would prefer not to use a data control object or ODBC.


I am trying to connect to a Microsoft Foxpro 2.6 DBF using ADODB but do not want to have to build a DSN to each table. Is there a way to connect using ADODB?