Connect to SQL Server from Powerpoint

sql-server vba powerpoint

11,971

Solution 1

Start looking into VBA for PowerPoint. This helps with referencing the objects and manipulating PP. You'll need to look into using SQL Server for VBA if you want to provide the content for TextFrames, grids, or Excel Charts.

Solution 2

I would Just do it in Excel, then embed the Excel object in PP Slide. Or Convert the Reports to Images use those.

Coding report in PowerPoint just seems wrong.

11,971

Author by

hangar18

Updated on June 05, 2022

Comments

hangar18 almost 2 years

How can I connect to a SQL DB from Powerpoint (be it 2007 or 2010) to generate reports? I've seen quite a few forums and most of them talk about using external tools.

Check http://www.officekb.com/Uwe/Forum.aspx/powerpoint/34863/Linking-PowerPoint-to-a-database

http://www.ljzsoft.com/pptreport/help/ppt-report-help.htm

Isnt there any out of the box solution for this?

P.S. I've also posted this at the MSDN Forum. Didnt get any replies hence posting it here
hangar18 almost 13 years

I agree with that you said, but I was thinking more on the lines of being able to generate the reports at runtime rather than have it in excel and then put it onto a powerpoint.
hangar18 almost 13 years

Thanks Jeff. I'll explore this option and see if it serves the purpose.
JeffO almost 13 years

PowerPoint is going to use Excel anyway for Charts. They're fairly well integrated.