535
Hello,
I am using CRM 2013 SP 1 UR 5 (On-Premise) Version. I need to export data more then ~10,000 with Advance Find. I can export 10,000 data with Dynamics Worksheet with CRM OOB Export FUnctionality.
When I am changing connection Proprty in exported Excel File, Connection Propery fields are locked and I am not able to change connection string or SQL Statement.
Is there any way to achieve this functionaly without using SQL Server?
Thanks in Advance
Jigar
*This post is locked for comments
Hi Jigar,
Seems you can not retrieve more than 10000 record in OOB functionality.
Apart from SQL query you can build console application and write data in the excel and using PagingCookie to retrieve more than 10000 record.
Here is the MSDN reference how to use PagingCookie to retrieve more than 5000 records using C#.
msdn.microsoft.com/.../gg328046.aspx
Here is the C# reference to export generic list( entity collection ) to export an excel.
www.c-sharpcorner.com/.../exporting-generic-listt-to-excel-in-C-Sharp-using-interop
you can get many reference in web to download excel using C#.
Hope this helps.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
