Can Sharepoint access

Posted on 2010-01-04
Last Modified: 2012-05-08
Can Sharepoint access Visual Foxpro 9.2 tables and data containers.  We are looking ot Sharepoint only to INPUT data, not process it (The Foxpro program will do that).  We will add the data to a table, then Foxpro will process.

Any opinons or suggestions are appreciated.

Question by:fmoore0001
    LVL 41

    Accepted Solution

    LVL 9

    Expert Comment

    by:Ivan Padabed
    good answer from pcelba, I would add some points: you can use workflow to propagate your data to FoxPro, you need to implement custom WF action for SPD WF or implement entire WF in MSVisual Studio. Another alternative is event receiver with this logic, it depends on when you want your data be sent to foxpro.

    Author Closing Comment


    Thanks, you got me on the right track.

    Expert Comment

    Other than the Layer2 product (listed above), is there a way to use SharePoint Services 3.0 to do real-time read-only access to VFP 8 or VFP 9 data tables or DBC views? The other links above, point to  SharePoint 2007 solutions.
    LVL 41

    Expert Comment

    VFP OLE DB provider always connects data in real-time, it does not use any copy.

    So, if SharePoint Services 3.0 support OLE DB data access then you should be successful. (Just FYI, SQL Server 2008 32 bit edition can create Linked server and access FoxPro data concurrently to running Visual FoxPro application.)

    I don't know more details and you should probably ask new question in SharePoint zone to become visible by more experts (old questions are not monitored obviously).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    758 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

    10 Experts available now in Live!

    Get 1:1 Help Now