function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AMS1AMS1 

Is there an upper limit of the size of an update possible via the Excel Connector?

Looking for the ability to update up to around 10,000 to 15,000 fields at a time.  Will this be possible via the excel connector?

GuyClairboisGuyClairbois

yes this is possible. The request will be broken up into pieces of 50 I believe (this is hardcoded in the VBA).

 

Alternatively, use this version where the standard batch size is 200:

http://boards.developerforce.com/t5/Excel-Connector/Updated-sForce-Excel-Addin-feel-free-to-use-edit/m-p/186779

Varun NagpalVarun Nagpal

This should be possible though excel connector, while I prefer Apex data loader for large amount of data updates. It is fast and doesnt hang.

jroyaltyjroyalty

The Apex data loader is not available for Professional edition, so many people are stuck using the Excel connector.