Accessing Linked Server using PowerPivot

• mbrady5

  SSCrazy

  Points: 2835

  More actions

  March 4, 2013 at 9:42 am

  #269273

  I am completely at a loss. Does anyone know the steps in connecting to a Linked server using Excel?

  Thanks

• eric.bassett

  SSC Journeyman

  Points: 81

  More actions

  May 8, 2014 at 8:37 am

  #1711886

  Enter the server name. Enter Master for the databse name.

  Then in the query specify [LinkedServer].[database].[Schema].[Table]