Share via

Is there a way to pull data from SQL into Powerpoint?

Anonymous
2012-03-11T03:42:03+00:00

I want to automate a monthly deck my team produces for a finance department by pulling data from a sql db into Powerpoint. For example, I want to show in a text box something like the following:

QTD Overall Results: $5M or 4% favorable to forecast

And I want the $5M and 4% to update based on which month I select as the current month. I have a table in SQL that does the math for me and it's easy to do something like this in Excel, but I haven't figured out a way to do it within Powerpoint.

Any ideas would be appreciated!

Microsoft 365 and Office | PowerPoint | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-03-11T06:45:10+00:00

    You may check below thread to see if that works to connect to SQL Server using ADO to retrieve data into your Presentation.

    http://social.msdn.microsoft.com/Forums/da-DK/officegeneral/thread/2e4bf40f-442f-42b6-8f89-d04a0d2068f5

    If that would be to complex you might just embed/ link an Excel file which has the data already:

    http://www.pptfaq.com/FAQ00593_Linking_or_copying_information-content-charts-worksheets_from_Excel_to_PowerPoint.htm

    Hope this helps,

    Daniel

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-12-14T12:18:41+00:00

    thanks !!!

    and

    this will be useful to all

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-12-14T12:09:57+00:00

    "To connect to SQL DB or any database, Excel or Flat files, refer to this link http://prodentechnologies.net/products/accelbiformsoffice.html

    This is a PowerPoint add-in that can be installed and configured to pull data from lots of data sources like Oracle, SQL Server, Access. The Standard Edition is free."

    Was this answer helpful?

    0 comments