Mohammed SII
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
ldifde -f Exportuser.ldf -s <Server1> -d "dc=Export,dc=com" -p subtree
-r "(&(objectCategory=person) (objectCla ss=User)(g ivenname=* ))"
-l "cn,givenName,objectclass, samAccount Name"
also check this.
http://support.microsoft.com/kb/276382
ldifde -f Exportuser.ldf -s <Server1> -d "dc=Export,dc=com" -p subtree
-r "(&(objectCategory=person)
-l "cn,givenName,objectclass,
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
Refer to the article:
http://blog.scottlowe.org/2006/06/20/mass-changes-in-active-directory/
Hope it works.
Thank you
Anil
ASKER
problem sloved
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