Connect FoxPro from two folders by ADO

Posted on 2005-05-08
Last Modified: 2010-04-05
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
Question by:namcit99
    LVL 5

    Accepted 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.


    Author Comment


    i should use FoxPro from two folders. No change
    LVL 5

    Expert Comment


    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).


    LVL 13

    Expert Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now