Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Connect FoxPro from two folders by ADO

Dear advisor !

I use Delphi 2005

I connect FoxPro Table by using ADO. Because those tables are exised on two folders. So how to write a query to retrieve data from two tables existing on two folders.

when setup paramater for ADO, they only permit to choice one folder

thank for all consider
  • 2
1 Solution


You can attach them to an Access Database, you can then query/join the tables and update them seperately as MSAccess will do the work.

Open MSAccess (you need MSOffuce to do this) File/GetExternalData/LinkTables.

One the tables are linked you can open the Access Database from Delphi and do what you like with the tables.

You can of course attach/link the tables in code if you want the whole thing to be dynamic.

I can't help with the code in Delphi, but I have often done this with Visual Basic without problem.

I don't use ADO with Delphi as I prefer EasyTable, Accuracer and DBISAM.

namcit99Author Commented:

i should use FoxPro from two folders. No change

How namcit99 ?

Each folder is treated as a seperate database (isn't it?), requiring two connections.  You cannot join tables on different connections (if you can I would be pleased to here how).


that's right, if you only wanted to use Foxpro, this is not possible, a workaround however is what Voodooman suggested, you are still using the Foxpro tables, but you access them different, trhough MSAccess or any other application that lets you link external tables

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now