Syncrinising Sharepoint lists

Posted on 2007-10-12
Last Modified: 2010-04-19
A customer has an accounting system with dbf-tables and a SBS with Sharepoint 3.
I would like to provide the customer list, Supplier list and actual projects list in the sharepoint portal for east access.
My question is if anybody has a suggestion of where to start. I have ODBC-drivers (VF) to collect the info but we can not have any hackersystem with hand on. That I can do already. I would like some code that once an hour updates the tables in sharepoint without any manipulation of the original dbf-files.
Do you have any suggestion where to start and what is needed??
Per B
Question by:perbackman
    LVL 74

    Expert Comment

    by:Jeffrey Kane - TechSoEasy
    What's the accounting system?

    If it's SQL Based, you don't need "once an hour updates" because you can display live data.

    But it would help to know what the accounting system is.



    Author Comment

    Dear TechSoEasy, No it is a foxprobased system with related dbf filer. I think the name is clipper or comix. Thanks
    LVL 74

    Accepted Solution

    Then the easiest way to do this would proabably be with Excel 2007 connecting to the FoxPro database via ODBC and then publishing the Excel Spreadsheet to Sharepoint.

    A couple of references:
    Working with Windows SharePoint Services 3.0 from Excel 2007

    Create a list based on a spreadsheet

    You can also connect data directly to a web part:

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
    You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now