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
KrystalKrystal 

Get Lookup fields with Exel Connector

Is it possible to get a lookup field with the excel connector?
I want to get the field (which should be the 18 digit ID for the table) with the Excel Connector.

Example:
I have a custom field on the account page that says "Reseller LookUp" and it is a lookup field that user can lookup to another account in our instance of Salesforce.
 
When I run the query to select every field in the account table in Excel using the Connector, it does not give me this "Reseller LookUp" field. 
 
Is it possible to get that field using the Connector?

Thanks!
Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/
You should be able to do that.  Have you searched the Online Excel Connector Guide?

http://sforce.sourceforge.net/excel/index.htm
http://sforce.sourceforge.net/excel/index.htm



Message Edited by Stevemo on 01-15-2009 10:15 AM

All Answers

Steve :-/Steve :-/
You should be able to do that.  Have you searched the Online Excel Connector Guide?

http://sforce.sourceforge.net/excel/index.htm
http://sforce.sourceforge.net/excel/index.htm



Message Edited by Stevemo on 01-15-2009 10:15 AM
This was selected as the best answer
BlueBloodBlueBlood

I must be missing something, so please excuse me being so dense.  I see this marked as an accepted solution, however, I cannot find a relevant entry in the Table of Contents for the sforce connector.

 

Is there a specific solution to the issue of not being able to see/update lookup fields using the sforce connector?

meighanmeighan
I'm having the same issue with lookup fields, hope to get details, and a yes or now answer soon.
BlueBloodBlueBlood

I found this thread helpful:

 

http://community.salesforce.com/sforce/board/message?board.id=sforceExplorer&thread.id=810

 

 

TOMITOMI

this link is broken, any chance to share that information?

 

Thanks,

ishai gal-on

ONE1 Salesforce team