Methods to populate Exchange contacts from SQL Server

Posted on 2008-11-04
Last Modified: 2012-06-22
I am looking for a tool or package to simply cater for the following:

A SQL Server table contains contact information that is updated by a software package. All users have outlook and wish to have the information in the SQL Server table containing the contact information to be available in Outlook.

My idea is to synchronise an Exchange public folder with all the contact data, which can then be accessed by all users (or per an access plan).

I have found reference to extended stored procedures for SQL Server which take care of this ( however it seems the site that hosts these stored procedures ( is no longer available.

Does anyone else have access to these extended stored procedures or information relating to a method of a similar nature?

Thanks in advance.
Question by:pldervey
    LVL 42

    Accepted Solution

    you can check this link :

    OLE DB Provider for Exchange

    LVL 51

    Assisted Solution

    by:Mark Wills
    Have tried that linked server before and couldn't make it happen for me...

    Ended up downloading and using GeniusConnect :

    Have also played with :

    Did come across a linked server / openquery object that did work, but after I had installed GeniusConnect. Will try to find it, though was a bit past it at the time...
    LVL 42

    Assisted Solution

    LVL 51

    Expert Comment

    by:Mark Wills
    Can also try OA procedures with CDO objects...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Easy CSR creation in Exchange 2007,2010 and 2013
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

    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