Discussion Locked

Adding 400 Users

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to add 400 users to a new active directory domain. I have all the users in an Excel spreadsheet. Is they a tool I can use to import the spreadsheet into active directory.
Thanks

6 replies

by rick_b

Thanks for your help. I added more points for the delay in getting back here.

by roniperk

Since you currently have the name in an Excel spreadsheet, use the CSVDE command line utility to import the names into an Active Directory Organization unit.

Here's a link to using the utility:

http://support.microsoft.com/default.aspx?scid=kb;en-us;300409

This article was previously published under Q300409
SUMMARY
This article describes how to use Csvde.exe to import contacts into the Active Directory. You can use files that are saved by export utilities in a Comma Separated Value(CSV) format to import contact information into the Windows 2000 Active Directory. To modify the file headers and data, you can use a spreadsheet program such as Microsoft Excel. The modified files can then be added as contacts to the Active Directory by using Csvde.exe in Import mode. Csvde.exe is the CSV Directory Export utility that is included with Windows 2000 Server, and is located in the %systemroot%\System32 folder.

The following sample CSV file adds a contact for John Doe to the Sales Organizational Unit (OU) in the MYDOMAIN.local domain. This file also creates the necessary Exchange SMTP addresses so that Outlook clients can select this contact from the Exchange 2000 Global Address List.

To view the file for this example:Copy and paste the following text into a plain text editor (such as Notepad), and then save the file with a .csv file extension:

DN,instanceType,distinguishedName,objectCategory,objectClass,name,cn,
displayName,mail,givenName,legacyExchangeDN,middleName,proxyAddresses,
showInAddressBook,sn,textEncodedORAddress,internetEncoding,mailNickname,
mAPIRecipient,targetAddress
"CN=John Doe,OU=Sales,DC=MYDOMAIN,DC=local",4,"CN=John Doe,
OU=Sales,DC=MYDOMAIN,DC=local","CN=Person,CN=Schema,CN=Configuration,
DC=MYDOMAIN,DC=local",contact,John Doe,John Doe,John Doe,
John@ISP.com,John,/o=MYDOMAIN/ou=first administrative group/cn=Recipients/cn=
John Doe,,SMTP:John@ISP.com;X400

by rick_b

Thanks for your help. I added more points for the delay in getting back here.

This discussion is closed to new replies.