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
savvyboardersavvyboarder 

excel connector + sandbox

Hi all-

 

Is there anyway to access the sandbox data with the SFDC Excel Connector? Any help is appreciated! 

 

BW

Best Answer chosen by Admin (Salesforce Developers) 
crop1645crop1645

This is easy. 

 

Three steps required:

 

  1. You'll need your security token for your userid in sandbox.  This will not be the same as the one you use in PROD
  2. When you use the sforce Connector plugin for Excel, you need to use your login for sandbox plus your password+securitytoken for the password field
  3. And last, be sure to change the endpoint to sandbox via the Advanced button. sandbox is https://test.salesforce.com/...

 

Excel connector login to sandbox

Message Edited by crop1645 on 04-14-2009 06:37 PM
Message Edited by crop1645 on 04-14-2009 06:39 PM

All Answers

crop1645crop1645

This is easy. 

 

Three steps required:

 

  1. You'll need your security token for your userid in sandbox.  This will not be the same as the one you use in PROD
  2. When you use the sforce Connector plugin for Excel, you need to use your login for sandbox plus your password+securitytoken for the password field
  3. And last, be sure to change the endpoint to sandbox via the Advanced button. sandbox is https://test.salesforce.com/...

 

Excel connector login to sandbox

Message Edited by crop1645 on 04-14-2009 06:37 PM
Message Edited by crop1645 on 04-14-2009 06:39 PM
This was selected as the best answer
dclaardclaar

Maybe that works in office 2003? Or with an older connector? Because with Add-in Version 1.8.0.7, Excel Version 12.0, Worksheet version 1.8.0.7, there's no Advanced button.