function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Padma_sfdcPadma_sfdc 

query table data

Hi,

  I have a list of account id's in excel and i want to use excel connect query table data to get a bunch of other columns from account table corresponding to the account id's i have. I tried using refresh

 

This is what I have in excel

 

    Account Account ID Account Refresh         

    Account ID Account ID Account Name Owner ID

0018000000dglatAAA 

0018000000dgHKLAA2

0018000000dgGXjAAM 

 

I get the below error

 

Salesforce: Query()

invalid Range, missing data type, or other error,

type is Account

Object variable or With block variable not set

 

I am new to using Excel connector. Any help is appreciated.

 

Thanks

 

cactusdavecactusdave

Basically what you want to do is trick it by doing the following. 

 

1. Use the Connection Wizard, selecting every column. Don't put anything on the filter criteria and press run.

2. While it is running, press ctrl+break to stop the query.

3. Remove all rows except for the results headers (leave row 1 and row 2)

4. On the AccountID column, add the three records (just column a will be populate)

5. Choose "Query Selected Rows" from the Excel Connector

 

Voila! You should all of the fields populated for those account IDs.