Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

CRM 3.0

When you export records from CRM 3.0 to Microsoft Excel only the first 10,000 rows are exported. Unless you scroll to the end of the spreadsheet there isn’t any kind of indication that a limit has been reached. The following post from Microsoft walks you through the steps necessary to increase the limit.

http://support.microsoft.com/kb/911395

CRM 4.0

To change this in CRM 4.0:
1. Log-in to the SQL Server where the _MSCRM database is stored
2. Open the OrganizationBase table
3. FInd the Column: MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
5. Committ the change to the database

Advertisements

5 thoughts on “Exporting more than 10,000 records to Excel in CRM 3.0/CRM 4.0

  1. Dylan

    Hi πŸ™‚

    I did these things.. but unfortunately, it didn’t work. We might be able to extract more than 10000 records but I think the problem here is the Number of Columns. Should there be any limit?

    Reply
      1. Dylan

        yep.. there’s no limit.. but the records we are trying to export is more than 10000 and have lots of columns included. Aside from taking too much time in extraction, a dialog box appeared saying that an error has occurred after waiting for 5 mins or so.

        I have tried exporting those data by lessening the number of columns and the extraction worked. So that means that the problem is having too many columns 😦

        Do you think that the problem is a timeout error? Because it’s taking too long?

      2. Dylan

        Hello,

        Thank you for your reply. Will try to work on it and see if this works. πŸ™‚

        Thank you very much πŸ™‚

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s