I need to know if there is anyway to use query language on dbaseIV files using VB6 and adodb (or other data access).
For instance, I would like to be able to "Select Cmaster.CustName, Cmaster.Salesman, Orders.Order_Number, Orders.Order_Value from Orders inner join Cmaster on orders.Account = Cmaster.Account".
Cmaster and Orders are both dbaseIV files.
I do have MSSQL Server 2008 if there is a way to do it through sql server.
Thanks for you input!