E
EarthwormJim
Subject: Power Point Slide presentation retrieving and updating information
into a SQL Server database.
I am currently working on a project with Power Point. The requirements for
the project is that I must 1) take input(s) in the Power Point and insert it
into a Microsoft SQL Server database. Then 2) I must be able to extract the
information from the Microsoft SQL Server database and re-populate a Power
Point template with the information retrieved from the Microsoft SQL Server
database.
The issue is this 1) Power Point is a flat file which means that it has no
intelligence. However, we can add intelligence to the flat file by means of a
desk top programming language Visual Basic for Application (VBA). 2) Visual
Basic for Application (VBA) is the industry standard for embedding
intelligence into a flat file. VBA is used by industry to place embedded
objects into Excel, PowerPoint, Microsoft Wrod and Microsoft Access. 3) The
problem is that VBA was NOT originally designed to connect to a Microsoft SQL
Server database. Originally it was designed to connect to Excel and Microsoft
Access. Also, after much Googling , I get the impression that VBA does not
supports ADO.NET access to Microsoft SQL Server.
My thoughts are this, if VBA connect access Microsoft SQL server directly
then maybe we can use it to connect to Microsoft Access and then have
Microsoft Access feed into a Microsoft SQL Server database.
(I.E. shown below...)
Solution # 1)
My own personal recommendation for inserting data from Power Point to
Microsoft SQL Server database: “Embed VBA objects into Power Point 2) then
have the embedded VBA objects in the Power Point slides feed into a Microsoft
Access database. 3) Have the Microsoft Access database feed into a Micrsosoft
SQL Server Database.†– this will ensure that our data is stored in a SQL
Server database.
My recommendation for outputting data from Power Point to Microsoft SQL
Server database:
“Have the Microsoft SQL Server database feed into a Microsoft Access
database. Then have the Power Point Slides retrieve the data from the
Microsoft Access database.
Solutions #2)
My own personal recommendation for outputting data from Power Point to
Microsoft SQL Server database:
“Have the Microsoft SQL Server database feed into a Microsoft Access
database. Then have the Power Point Slides retrieve the data from the
Microsoft Access database.
Request for comment/recommendations . . . also, if somebody worked on a
similiar project, know how to connect directly to SQL Server from VBA, or
know of an application that can perform the functionality stated please reply
back to this posting or my e-mail (e-mail address removed).
into a SQL Server database.
I am currently working on a project with Power Point. The requirements for
the project is that I must 1) take input(s) in the Power Point and insert it
into a Microsoft SQL Server database. Then 2) I must be able to extract the
information from the Microsoft SQL Server database and re-populate a Power
Point template with the information retrieved from the Microsoft SQL Server
database.
The issue is this 1) Power Point is a flat file which means that it has no
intelligence. However, we can add intelligence to the flat file by means of a
desk top programming language Visual Basic for Application (VBA). 2) Visual
Basic for Application (VBA) is the industry standard for embedding
intelligence into a flat file. VBA is used by industry to place embedded
objects into Excel, PowerPoint, Microsoft Wrod and Microsoft Access. 3) The
problem is that VBA was NOT originally designed to connect to a Microsoft SQL
Server database. Originally it was designed to connect to Excel and Microsoft
Access. Also, after much Googling , I get the impression that VBA does not
supports ADO.NET access to Microsoft SQL Server.
My thoughts are this, if VBA connect access Microsoft SQL server directly
then maybe we can use it to connect to Microsoft Access and then have
Microsoft Access feed into a Microsoft SQL Server database.
(I.E. shown below...)
Solution # 1)
My own personal recommendation for inserting data from Power Point to
Microsoft SQL Server database: “Embed VBA objects into Power Point 2) then
have the embedded VBA objects in the Power Point slides feed into a Microsoft
Access database. 3) Have the Microsoft Access database feed into a Micrsosoft
SQL Server Database.†– this will ensure that our data is stored in a SQL
Server database.
My recommendation for outputting data from Power Point to Microsoft SQL
Server database:
“Have the Microsoft SQL Server database feed into a Microsoft Access
database. Then have the Power Point Slides retrieve the data from the
Microsoft Access database.
Solutions #2)
My own personal recommendation for outputting data from Power Point to
Microsoft SQL Server database:
“Have the Microsoft SQL Server database feed into a Microsoft Access
database. Then have the Power Point Slides retrieve the data from the
Microsoft Access database.
Request for comment/recommendations . . . also, if somebody worked on a
similiar project, know how to connect directly to SQL Server from VBA, or
know of an application that can perform the functionality stated please reply
back to this posting or my e-mail (e-mail address removed).
