Sign in

Microsoft.com

Microsoft

Remove From My Forums

Reading data from Excel sheet and inserting/updating into the MS CRM 2011.

Question
0

Sign in to vote
Hi,

I have the requirement to read data from Excel sheet and inserting/updating into the MS CRM 2011 as records using console application.

At the same time I need to log the details.

Can you please provide the solutions or useful links.

Thanks

Srikanth Reddy
- Edited by Srikanth_MSCRM Wednesday, June 3, 2015 6:03 AM
Wednesday, June 3, 2015 6:02 AM

All replies

1

Sign in to vote

Hello Srikanth:

Basically what you need to do (with some usefull links):

Read an Excel File (.xlsx): http://csharp.net-informations.com/excel/csharp-read-excel.htm
Read an Excel File (.csv): http://stackoverflow.com/questions/5282999/reading-csv-file-and-storing-values-into-an-array

1. Process your data
2. Create/Update objects in CRM: https://msdn.microsoft.com/en-us/library/gg328416.aspx
3. Log your actions to a txt file: https://msdn.microsoft.com/en-us/library/3zc0w663%28v=vs.110%29.aspx

Kind Regards

Wednesday, June 3, 2015 6:52 AM