Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Extracting query for excel sheets RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Not really sure whether this should be in the Excel or the CRM forum...
    I have some excel sheets which are dynamically linked with MS CRM, and refresh when I press the refresh from CRM button on the ribbon.
    Thing is, im not sure what the queries being sent are.

    Is there any way for me to access the queries being sent to CRM from which the data is being refreshed ?

    Monday, June 4, 2012 8:55 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Yes you can access the query, follow these steps:

    1. In Excel sheet click on Data->Connections

    2. Select Connection and click on Properties button

    3. Click on Definition tab and look in Command text field for query

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".


    Monday, June 4, 2012 8:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I don't know whether this is because we are using CRM Online, but the Command Text field is a complete blank :(

    

    Monday, June 4, 2012 9:23 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    SQL Qeury  is only available for CRM On Premise version and CRM online does not execute any Query directly on DB but rather than uses CRM Excel add-on (installed with Outlook client) for retrieving/Refreshing data.

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".




    Monday, June 4, 2012 9:26 AM