You need to sign in to do that
Don't have an account?
AMS1
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?
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
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.
The Apex data loader is not available for Professional edition, so many people are stuck using the Excel connector.