Import user from Excel

  • Thread starter Thread starter Anders
  • Start date Start date
there are basically two methods:

1. Create Excel file with correct format and users and then save it in csv
format. Use csvde utility to import users into AD. To see the format in
which your data should be use csvde to do an export of users out of AD. The
only mandatory field you have to specify is object cn and sAMAccountName
2. Another option is to create a script in VBA in excel which runs trough
your users and creates account in AD. Send me an mail and I will send you
Excel file with appropriate VBA code.

--

Regards

Matjaz Ladava, MCSA, MCSE, MCT, MVP
Microsoft MVP Windows Server - Active Directory
(e-mail address removed), (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bulk Import from Lotus 3
Excel How to Repair Excel Files? 1
Microsoft Works to Microsoft Office 6
Import only selected users- ldifde 5
import accout from excel file to Active Directory 2
Import 4 Different Excel Files from One Folder 0
Access Subscript out of range when importing into access 2010 from excel 0
import active directory users account 1

Back
Top