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
metal_augmetal_aug 

Accessing a Lookup field with SQL

- A SalesForce Account has a Lookup field.

 

- I am trying to retrieve its value with an SQL statement in VBA Excel.

 

- An error message appears, saying the field does not exist, even if it does.

 

- The SQL statement is formed correctly and I use the correct field name with the __c .

 

- All other SalesForce fields of that same account can be accessed by the SQL statement just fine.

 

- Is there a special way to access a SalesForce Lookup field with SQL in VBA Excel?

 

Thanks.

 

pic

Message Edited by metal_aug on 03-03-2009 07:10 AM
Message Edited by metal_aug on 03-03-2009 07:12 AM
jobojobo
not without a third party tool (charges) ... try to understand soql and try office toolkit 4.0 to start with no-joins for first results if you're in a hurry.