Populating AD

[AFord]

This is the deal:

I have and excel spread sheet (cvs file) with 5000 rows
(Fname, Lname, address, phone number 'wk & hm', zip code,
SS#, and several other colums). I want to populate AD
(create user accounts) with the information listed. Is
there something out there that will do what I'm trying to
do. I also have a delimited text file with the
information, and I've imported all the information into a
SQL Server 2000 table. Sooo, if there is a script that
could read from any of the 3 sources (Excel Spread sheet,
Text file, or SQL Server 2000 table) Let me know.

I'm thankful for any and all help.

AFord

 

[Jason Opdycke [MSFT]]

Hello -

This article should help...

327620 HOW TO: Use Csvde to Import Contacts and User Objects into Active
http://support.microsoft.com/?id=327620

 

[Jason Robarts [MSFT]]

http://msdn.microsoft.com/library/en-us/netdir/ad/user_object_user_interface_mapping.asp?frame=true
and
http://msdn.microsoft.com/library/en-us/netdir/ad/user_object_attributes.asp?frame=true
has additional information on user attributes that can used with the ones
specified in the KB.

 

[Mike Miller]

This is the deal:

I have and excel spread sheet (cvs file) with 5000 rows
(Fname, Lname, address, phone number 'wk & hm', zip code,
SS#, and several other colums). I want to populate AD
(create user accounts) with the information listed. Is
there something out there that will do what I'm trying to
do. I also have a delimited text file with the
information, and I've imported all the information into a
SQL Server 2000 table. Sooo, if there is a script that
could read from any of the 3 sources (Excel Spread sheet,
Text file, or SQL Server 2000 table) Let me know.

I'm thankful for any and all help.

AFord

If none of the other options that have been posted work for you I have a
PERL script that can be tweeked to do what you need. Right now it takes
command line input from a calling app(UNIX) and spits out a VBS script to
run on the Windows side.

 

[AFord]

Thanks Gents!!