Exchange 2010 and Access
After installing Exchange 2010 i wondered if i could import data from my Access 2007 database where my contacts are store. I had a server breakdown and my backup were all corrupted. So the only way is to manually type all in Exchange contacts or if i could import the data from the database. The database has more then 4.000 contacts.Server is running 2008 R2 and Exchnage 2010. Office is Access 2007.
January 4th, 2010 10:58pm

Powershell is your friend. A Powershell script with the Exchange management shell imported would be able to open a connection to the database file, read the contents and use the EMS cmdlets to create the contacts in Exchange.
Free Windows Admin Tool Kit Click here and download it now
January 5th, 2010 12:12am

You could do this by creating a CSV file and then importing that into a New-Mailcontact command.Example: CSV File: Name,email John Doe,jdoe@mail.com Command: import-csv C:\contact.csv | foreach { New-MailContact -alias $_.name + 'fwd' -Name $_.name -ExternalEmailAddress $_.email -OrganizationalUnit 'EXCH.ORG/Contacts' } SF - MCITP:EMA, MCTS: Exchange 2010, Exchange 2007, MOSS 2007, OCS 2007 -- http://www.scottfeltmann.com
January 5th, 2010 12:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics