Merging Excel or CSV file to Active Directory

1110 pts.
Tags:
Active Directory
Active Directory migration
CSV
microsoft excel functions
How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can use Ldifde to import that list . This is a tool included on the Windows 2000 resource cd and is installed with 2000 and 2003 server. ldifde.exe is provided natively with the W2K and W2K3 OS and is located in %systemroot%\system32

This is what MS has to say about it:

The LDAP Data Interchange Format (LDIF) is a draft Internet standard for a file format that may be used for performing batch operations against directories that conform to the LDAP standards. LDIF can be used to export and import data, allowing batch operations such as add, create, and modify to be performed against the Active Directory. A utility program called LDIFDE is included in Windows 2000 to support batch operations based on the LDIF file format standard. This article is designed to help you better understand how the LDIFDE utility can be used to migrate directories.

You can find the syntax and paramaters <a href=”http://support.microsoft.com/kb/237677″>here</a>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following