Forum Discussion

BuckyKat37's avatar
BuckyKat37
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Can you pull Salesforce field labels?

When pulling data from Salesforce, is there a way to use field labels instead of the field names when using the Salesforce connector? For instance, rather than having a column named "c4g_Lead_Rating__c" I want it to use the Salesforce label "Lead Rating". It's easy to figure out the labels for default columns but the custom field labels in large tables can be tricky if a consistent naming schema wasn't used.

I did run across a Microsoft support article titled "Link to or import data from Salesforce" that talks about how to link Access to Salesforce. However, the connector dialog you get in Access allows for connection string parameters where you can add a USELABEL option so the columns use the field label instead of the field name.

2 Replies