Solved

Import Excel Files into Active Directory

Posted on 2006-11-20
1
181 Views
Last Modified: 2010-04-18
I have Windows 2003 Server, I have and Excel file with all my Contacts information in it, I wanted to know if there was a way for me to Import this excel file into my AD?
0
Comment
Question by:j_man202
1 Comment
 
LVL 38

Accepted Solution

by:
Shift-3 earned 500 total points
ID: 17982232
Yes.  Save it as a comma-delimited text file (.csv) and then import it using CSVDE.  This KB article has instructions:
http://support.microsoft.com/kb/327620

It would probably be best to do a CSVDE export of existing accounts and then copy the spreadsheet data into the appropriate fields.  This should ensure that the formatting is correct.

This site has some more examples:
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_import.htm
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question