This tool we can use for import and export data from the Active directory and store those data in comma separated format(CSV)
For creating csv file that easy to use excel 2010 or excel 2007
Figure 1.0
This is the one of the example csv file which has entered some sample data.Once we enter the data we can save this as a csv on a domain controller or additional domain controller
Now we can start the import user accounts using csvde.exe
All the user accounts are in disabled mode because we cannot give the password from the csvde
how to add the username for this?
just enlarge that excel sheet,Userprinciple name and samaccountname is there.For get that upn and samaccount name i have used some excel functionas(concatanate,ltrim)