I have a powerpoint presentation running continuously.
Is there a way to update one of the slides of this presentation automatically with data from a MySQL database?
Specifically, the data I need is to be returned from mysql stored procedure.
PROCEDURE sp_MatrixTotals
(IN p_start_date DATETIME, IN p_end_date DATETIME, IN p_start_date1 DATETIME, IN p_end_date1 DATETIME)
First download connector ODBC with this complement installed, configure a New odbc source (MySql) and select the database which you need.
So, in your Power Point you can insert a Excel Spreadsheet, an object will be inserted, make a right click on the Excel Object and select the option:
Spreadsheet Object > Open
Then Excel application will be open, in this window you can select:
Data > From other sources > From Microsoft Query
The asistant helps to select the column that you need with a Sql query or select each column, as well.
But, if you can install other tools, use MySql for Excel with this tool you can call any object from mysql (views and routines included) read this post from Oracle.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments