Sql Server Programming :: Import Exchange Contacts


	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... - Hide quoted text - > 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 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... - Hide quoted text - > 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. 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.