Import user-specific data from a Excel-sheet into Active Directory/Exchange

I would like to allocate data from a Excel-sheet (name, department, phone etc.) to available AD-users automatically.

Which programming-/sc开发者_开发问答ripting-language or LDAP-API is practical for this problem? Does anyone have some examples?

---

Powershell or VB. There are examples of adding / updating users from .csv data posted in the Technet Scirpt Center Repository. http://gallery.technet.microsoft.com/ScriptCenter/

---

If its readily avaialble to you, go with PowerShell.

Use the Quest AD Cmdlets along with the Import-CSV Cmdlet. The only trick would be having to save your Excel file as a csv file. If that is not an option, you can use COM to automate excel.