On Jun 6, 8:59 am, "David C" <dlch
> 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.
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
Select a folder to export from [choose Contacts] /
Save exported file as [choose filename] /
The following actions will be performed: export "Contacts" from
[ choice to map custom fields here ]
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
(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.
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.
@gmail.com> wrote in message
On Jun 6, 11:08 am, "David C" <dlch
> 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
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:
you could then loop through everyone's mailbox, loop through the
items, and insert into a linked SQL server table.