Solved

VB.net - pull SQL data into PowerPivot

Posted on 2012-03-14
4
481 Views
Last Modified: 2012-03-18
Hi

Is it possible to query a SQL database in PowerPoint from VB.net and bring the results into an Excel PowerPivot?

What sort of code would I use?

Thanks
0
Comment
Question by:murbro
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Crashman
ID: 37721710
you can create the query in the power pivot and retrieve the values
0
 

Author Comment

by:murbro
ID: 37728729
Hi. Thanks. Would you be able to direct me to an example of code for that
0
 
LVL 8

Accepted Solution

by:
Crashman earned 500 total points
ID: 37729569
0
 

Author Closing Comment

by:murbro
ID: 37735208
Thanks very much
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question