Link to home
Start Free TrialLog in
Avatar of Mohammed SII
Mohammed SIIFlag for Saudi Arabia

asked on

how to import the User details in Ative Driectory from Excel

Dear Experts
we are using AD 2003, in AD only user account has been created. they are 150 users, now i want to update users details in AD at one single step with Excel Sheet.
1.  i have exported all  user account in the excel sheet.
2. then i have updated all the users accounts details in excel. now i want to import the excel sheet to AD 2003, so that all the users should be updated in signal step


ASKER CERTIFIED SOLUTION
Avatar of gaurav05
gaurav05
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandesh Dubey
Windows server provide you with 2 utility tools to modify existing AD accounts - CSVDE or LDIFDE
http://www.computerperformance.co.uk/Logon/CSVDE_LDIFDE.htm

What you do is to export your AD user accounts into a csv/spreadsheet, modify it and import it back to AD. Easy.

CSVDE
http://technet2.microsoft.com/WindowsServer/en/Library/1050686f-3464-41af-b7e4-016ab0c4db261033.mspx

LDIFDE
http://support.microsoft.com/kb/237677
Hi,

ldifde -f Exportuser.ldf -s <Server1> -d "dc=Export,dc=com" -p subtree
-r "(&(objectCategory=person)(objectClass=User)(givenname=*))"
-l "cn,givenName,objectclass,samAccountName"

also check this.
http://support.microsoft.com/kb/276382
Hi,

Refer to the article:

http://blog.scottlowe.org/2006/06/20/mass-changes-in-active-directory/

Hope it works.

Thank you
Anil
Avatar of Mohammed SII

ASKER

problem sloved