Problem solve Get help with specific problems with your technologies, process and projects.

Simultaneously add telephone numbers to Active Directory

You don't have to add a large group of numbers to Active Directory one by one. SearchEchange.com expert David Sengupta shows you the tool you need to get the job done in one sweep.

When our Active Directory was created, they didn't put in the telephone numbers. Is there any way to add the telephone numbers for 500 people without having to go into Active Directory and put in the numbers one by one? Human Resources sends out a telephone directory in Excel; can I use that to my benefit?
You should have a look at LDIFDE. See Microsoft Knowledge Base Article 237677: Using LDIFDE to import and export directory objects to Active Directory for instructions on how to make these changes. You'll need to be creative in Excel (or Access) in order to match up the source data from Human Resources with Active Directory data using some unique primary key.

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from SearchExchange.com:

  • Glossary: Lightweight Directory Access Protocol (LDAP)
  • Expert Advice: How to update multiple mailbox properties
  • 15 tips in 15 minutes: Managing recipients and distribution lists
  • Reference Center: Active Directory tips and resources
  • Dig Deeper on Exchange Server setup and troubleshooting