Home > IT Answers > Lotus Domino > Compare values Excel vs Lotus
LotusScriptMex
5 pts.
 Compare values Excel vs Lotus
Lotus Notes Database, Microsoft Excel
I have a database with 200,000 clients in Lotus Notes with a form call Enquiries, with these values: Name, Last Name and email and so; also I have a field in excel call Clients.xls with 2,000 rows with columns Name, Last Name and Email. I need to compare the clients in Excel with the ones in Lotus. I need to writte the result back to the excel file just with YES or NO in case the client exist. Does anyone can help me? please

Software/Hardware used:
ASKED: August 11, 2008  3:55 PM
UPDATED: August 14, 2008  3:20 PM
RELATED QUESTIONS
Answer Wiki:
This compare could be done with a custom LotusScript agent. You would need to choose a field to match on, either name or email address. I could do this for you, but it wouldn't be free. Contact me if you want a price quote. My email is in my profile.
Last Wiki Answer Submitted:  August 14, 2008  3:20 pm  by  Jason7   15 pts.
All Answer Wiki Contributors:  Jason7   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _