Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Import Exchange Contacts


Is there any way to import a users Exchange contacts into an SQL Server 2005
database?  I looked at the Import Data option but I didn't see anything
there.  Thanks.

David

not sure if there is an automated way, but you could export them to a CSV or
Tab Delimted file and then import them into SQL?

"David C" <dlch@lifetimeinc.com> wrote in message

news:OrW5orDqHHA.960@TK2MSFTNGP03.phx.gbl...

On Jun 6, 8:59 am, "David C" <dlch@lifetimeinc.com> wrote:

> Is there any way to import a users Exchange contacts into an SQL Server 2005
> database?  I looked at the Import Data option but I didn't see anything
> there.  Thanks.

> David

You don't mention which version of Exchange you're using.  But version
5.5 had a utility for exporting the Global Address Book to a CSV file.

Then again, Exchange doesn't have Contacts, to the best of my
knowledge. Outlook does have contacts, and can store them in a folder
on an Exchange mailbox; the distinction is subtle but real. It means
you can't do it right from Exchange, you have to get Outlook involved.

Once again, you don't mention what version of Outlook you are using,
but probably all versions have the ability to export contacts. I know
in Outlook 2003 I can do

(menu) File / Import and Export
(wizard)  Export to a file /
   Comma Separated Values (Windows) /
                       [ other interesting choices include MS
Access ]
    Select a folder to export from [choose Contacts] /
   Save exported file as [choose filename] /
  The following actions will be performed: export "Contacts" from
folder: Contacts
     [ choice to map custom fields here ]
  Finish

Now you have a CSV file, which you can bulk import or use SSIS to get
into SQL Server.

The other way to go involves using Microsoft Access 2000 or higher as
an intermediary, which can do something similar by importing from
Outlook:

(menu) File / Get External Data / Import
(dialog) Files of type: Outlook()
(wizard) From which folder would you like to import?
                [choose Outlook / Address Books / Outlook Address
Book / Contacts
                 or Mailbox - Contacts]
(wizard) Where would you like to store your data
                [ create a new table here ... OR .. use a linked table
to your database server ]

There are probably some more options here that I haven't explored, too.

-----------------------------------------------Reply-----------------------------------------------

I found the import/export.  Sorry, we are using Exchange 2003 and Office
2003.  I see that each user will have to export their contacts so I can
import them into SQL Server.  I see that Access is an export type but I
wonder if that is only available if you have Access on your PC.  Thanks.

David

"rpresser" <rpres@gmail.com> wrote in message

news:1181142085.126013.61680@h2g2000hsg.googlegroups.com...

On Jun 6, 11:08 am, "David C" <dlch@lifetimeinc.com> wrote:

> I found the import/export.  Sorry, we are using Exchange 2003 and Office
> 2003.  I see that each user will have to export their contacts so I can
> import them into SQL Server.  I see that Access is an export type but I
> wonder if that is only available if you have Access on your PC.  Thanks.

If you have permissions to everyone's mailbox, you can do all the
exporting yourself by temporarily adding their mailboxes to your
Outlook profile.

I tried importing from such mailboxes into access on my machine, but
it said it couldn't access the mailbox. Couldn't figure it out. If you
could get that to work, you could probably automate the whole deal.

Yet another tack is to access outlook items from code as shown here:

http://support.microsoft.com/kb/170320

you could then loop through everyone's mailbox, loop through the
items, and insert into a linked SQL server table.

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc