Add user from Excel file

[Joe]

I have a Excel file with user name and password.
How can I write a script or any command to import the informatrion from
Excel into AD on Server 2003?

Thanks,
Joe.

[Ace Fekay [MVP]]

Post by Joe
I have a Excel file with user name and password.
How can I write a script or any command to import the informatrion
from Excel into AD on Server 2003?
Thanks,
Joe.

Change the file to a CSV file and use CSVDE to import it.

How to use Csvde to import contacts and user objects into Active ...This
step-by-step article describes how to use the Csvde.exe utility to create
contacts and user accounts in Active Directory.
http://support.microsoft.com/kb/327620


CSVDECsvde is a command-line tool that is installed in the %windir%/system32
folder on Windows Server 2003 by default. To run csvde on a computer running
Windows ...
http://technet2.microsoft.com/WindowsServer/en/Library/1050686f-3464-41af-b7e4-016ab0c4db261033.mspx
--
Regards,
Ace

This posting is provided "AS-IS" with no warranties or guarantees and
confers no rights.

Ace Fekay, MCSE 2003 & 2000, MCSA 2003 & 2000, MCSE+I, MCT,
MVP Microsoft MVP - Directory Services
Microsoft Certified Trainer

Infinite Diversities in Infinite Combinations

Having difficulty reading or finding responses to your post?
Try using Outlook Express or any other newsreader, configure a news
account, and point it to news.microsoft.com. Anonymous access. It's
easy and it's free:

How to Configure OEx for Internet News
http://support.microsoft.com/?id=171164

"Life isn't like a box of chocolates or a bowl of cherries or
peaches... Life is more like a jar of jalapenos. What you do today
may burn your butt tomorrow." - Garfield

[Joe]

Thanks Ace Fekay.

The CSVDE cannot set user password. How can I do that?
Thanks,
Joe.

Post by Ace Fekay [MVP]

Post by Joe
I have a Excel file with user name and password.
How can I write a script or any command to import the informatrion
from Excel into AD on Server 2003?
Thanks,
Joe.

Change the file to a CSV file and use CSVDE to import it.
How to use Csvde to import contacts and user objects into Active ...This
step-by-step article describes how to use the Csvde.exe utility to create
contacts and user accounts in Active Directory.
http://support.microsoft.com/kb/327620
CSVDECsvde is a command-line tool that is installed in the %windir%/system32
folder on Windows Server 2003 by default. To run csvde on a computer running
Windows ...
http://technet2.microsoft.com/WindowsServer/en/Library/1050686f-3464-41af-b7e4-016ab0c4db261033.mspx
--
Regards,
Ace
This posting is provided "AS-IS" with no warranties or guarantees and
confers no rights.
Ace Fekay, MCSE 2003 & 2000, MCSA 2003 & 2000, MCSE+I, MCT,
MVP Microsoft MVP - Directory Services
Microsoft Certified Trainer
Infinite Diversities in Infinite Combinations
Having difficulty reading or finding responses to your post?
Try using Outlook Express or any other newsreader, configure a news
account, and point it to news.microsoft.com. Anonymous access. It's
How to Configure OEx for Internet News
http://support.microsoft.com/?id=171164
"Life isn't like a box of chocolates or a bowl of cherries or
peaches... Life is more like a jar of jalapenos. What you do today
may burn your butt tomorrow." - Garfield

[Ace Fekay [MVP]]

Post by Joe
Thanks Ace Fekay.
The CSVDE cannot set user password. How can I do that?
Thanks,
Joe.

No, it cannot. Once imported, use LDIFDE to set a password:

How to Use LDIFDE to import and export directory objects to Active ...
The LDAP Data Interchange Format (LDIF) is a draft Internet standard
for a file format that may be used for performing batch operations against
directories ...
http://support.microsoft.com/kb/237677


How to set a user's password with Ldifde
http://support.microsoft.com/kb/263991

LDIFDE - Export / Import data from Active DirectoryBy default account is
disabled when imported and also password is set to NULL. ... If you do an
LDIFDE or CSVDE export, many of the attributes for user and ...
http://support.microsoft.com/kb/555634


Ace