Importing Exchange Contacts to SQL

I have been trying to accomplish the same thing but have not been able to do
so in SQL. Were you able to accomplish this task?
"Terry" wrote:

> Hi everyone,
> We have a contacts database on SQL. but also a large number of users stori
ng
> contacts within Exchange.
> What I'd like to do is be able to extract Exchange Contact data, maybe on
a
> nightly basis, into SQL.
> What would be the best way to achieve this? Could i use a linked server?
> I've found various snippets of VBA, but nothing that looks like it could
> achieve what i need.
> Any ideas?
>
>http://msdn.microsoft.com/library/d...ado_objects.asp
This lists how to connect to exchange using ADO.
I did this once (and I don't claim this is the right way) to see if it was
possible.
MS access comes with a driver to link Exchange/outlook folders.
You can link the global address list under "address books".
Then import the contacts to SQL Server using DTS.
There are a few different ways I can think of doing this, the above simply
being the easiest (not the right way).
Simon Worth
"Sonya" <Sonya@.discussions.microsoft.com> wrote in message
news:19F1C665-AAAF-4F72-9ADB-6FAC7B3F85F5@.microsoft.com...
> I have been trying to accomplish the same thing but have not been able to
do
> so in SQL. Were you able to accomplish this task?
> "Terry" wrote:
>
storing
on a|||Simon,
Thank you. I'm not major programmer, I have some things but mostly in SQL
and some Active X scripting. Do I have to Visual Studio to use this code in
the link that you provided or can I use this in DTS ActiveX?
Thanks again for your response, I hope I can use it.
"Simon Worth" wrote:

> http://msdn.microsoft.com/library/d...ado_objects.asp
> This lists how to connect to exchange using ADO.
> I did this once (and I don't claim this is the right way) to see if it was
> possible.
> MS access comes with a driver to link Exchange/outlook folders.
> You can link the global address list under "address books".
> Then import the contacts to SQL Server using DTS.
> There are a few different ways I can think of doing this, the above simply
> being the easiest (not the right way).
> --
> Simon Worth
>
> "Sonya" <Sonya@.discussions.microsoft.com> wrote in message
> news:19F1C665-AAAF-4F72-9ADB-6FAC7B3F85F5@.microsoft.com...
> do
> storing
> on a
>
>|||Oh another thought,
I want to be able to do this from the Server level, meaning being able to
pull the contacts from every user that is a member of a particular group.
Therefore, I'm hoping that this is something that I would not have log on to
every user's mailbox individually to export their contact folder.
"Simon Worth" wrote:

> http://msdn.microsoft.com/library/d...ado_objects.asp
> This lists how to connect to exchange using ADO.
> I did this once (and I don't claim this is the right way) to see if it was
> possible.
> MS access comes with a driver to link Exchange/outlook folders.
> You can link the global address list under "address books".
> Then import the contacts to SQL Server using DTS.
> There are a few different ways I can think of doing this, the above simply
> being the easiest (not the right way).
> --
> Simon Worth
>
> "Sonya" <Sonya@.discussions.microsoft.com> wrote in message
> news:19F1C665-AAAF-4F72-9ADB-6FAC7B3F85F5@.microsoft.com...
> do
> storing
> on a
>
>