Moving Outlook contacts data into SQL Table based on criteria

[DoctorV3774 via AccessMonster.com]

I have an Access database that links to Outlook Contacts folder. We would
like to set up a DTS package to move this information into a SQL Table.
However when i attempt to set up a DTS Package I cannot see the linked
Outlook Contacts folder or uaccess it. It is easy to link to it using MS
Access, but how can I get to it in SQL Server?

Thanks

 

[John Nurick]

I'm not a SQL Server person, but if the Contacts folder is in an
Exchange mailbox or public folder you may be able to point DTS at that.

Otherwise, as far as I know you'll need to write a query in Access to
push the data into a SQL Server table, or else import the data into a
"real" (as opposed to linked) Access table so DTS can find it.

 

[DoctorV3774 via AccessMonster.com]

How do i get DTS to see the Exchange Contacts? I never am able to find the
Contacts in DTS

 

[John Nurick]

I'm afraid I don't know. If you can't find it in BOL or MSDN I'd ask,
carefully, in a SQL Server newsgroup.