Post reply

import and export outlook contacts with sql server2008

  • April 21, 2012 at 1:01 am

    #256766

    hello all.

    I need to import from sql server to outlook contacats and export to sql server from outlook contacts.is there simple way to do this?is there T-Sql for this result?

  • April 21, 2012 at 6:30 am

    #1477058

    Not entirely sure what you are trying to do here, and whether this is a one-off task or if you want to regularly synchronize the DB with Outlook.

    You could simply export outlook contacts into a delimited file (CSV), depending on what version of outlook you have, it should be a pretty straight forward process: Export Outlook Contacts into CSV

    Then a very simple SSIS package (or even Import/Export Wizard) could push that data into your SQL DB.

    Vise-versa is also easy, you just create an SSIS package to export contact from the SQL DB table in a CSV delimited file, and using the Outlook Import Wizard, you could import your contacts stored on a SQL Server DB.

    Hope this helps!

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply