Probably the best way to do it is in Excel using VBA macros. Not to say its easy that way either, but that's what I've done with this kind of data in the past.
Its its going to be something recurring, it might be worth writing a VBScript to do it, however. ------------------------------------------------------ Roger D. Seielstad - MCSE Sr. Systems Administrator Inovis - Formerly Harbinger and Extricity Atlanta, GA > -----Original Message----- > From: Lum, David [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 26, 2002 3:06 PM > To: NT 2000 Discussions > Subject: Merging AD data with other CSV > > > Question du jour from me. I have two CSV files, one a user > listing from AD > (file1), another an employee directory (file2) from a > different source. What > I need to do is match the UserID's (common in both files) and > bring them > into file2 by matching the corresponding name. Simple, yes? > Except file2 has > more name detail than file1 - e.g. file1 has names like > "Adams, Pat" and > "Adams, Patricia" where file2 has "Adams, Patrick R" and > "Adams, Patricia > M". > > I've tried Excel's VLOOKUP with some success, but not enough > to use it for > merging 2300 UserID's to a list of 1600 employees. > > Ideas? I have Access 2000 as well but am not versed well > enough to figure > this simple procedure out... > > Thanks, > Dave Lum - [EMAIL PROTECTED] > Sr. Network Specialist - Textron Financial > 503-675-5510 > > ------ > You are subscribed as [EMAIL PROTECTED] > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe send a blank email to %%email.unsub%% > ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
